At 11:36 13/02/2016 -0500, Vince Bonly wrote:
I have followed suggestions given here to change to Text formatting
in the Source cells and in the targeted cell. Have noticed that it
appears the font and character size cannot be changed for the targeted cell.
No: you can change both, of course.
I have followed suggestions given here to change to Text formatting in the
Source cells and in the targeted cell.
Have noticed that it appears the font and character size cannot be changed for
the targeted cell.
The next time I have need for a drop-down list, I will try a leading < or '
At 17:22 12/02/2016 -0500, Vince Bonly wrote:
When '16 BVL Practice was used, IIRC, the ERR:519 showed.
Not for me (or probably anyone else!). I don't know what you are
getting wrong to achieve this: I think you must be putting "=" in the
cell to make a formula!
The cells within my Source
Vince, I’m not sure that it’s really necessary, but you might also format the
cells in your list box to text as well as the target range.
One thing that may save you some time: You can copy and paste the active cell
(the one in which the user chooses from the list). This will save you from
hav
When '16 BVL Practice was used, IIRC, the ERR:519 showed. The cells
within my Source were not formatted as text beforehand.
Next time, I will try that Shrink box.
TNX.
On 2/12/2016 4:38 PM, Brian Barker wrote:
At 16:18 12/02/2016 -0500, Vince Bonly wrote:
Came upon one glitch: I did not s
At 16:18 12/02/2016 -0500, Vince Bonly wrote:
Came upon one glitch: I did not see a Shrink button in my version
(4.1.2) of AOO on the right of the "cell range" box. What I did see,
after setting the Criteria-Allow to "Cell range", is an input line
after a "Source" prompt.
The Shrink button is
Jim:
I have had success with this issue, by following your guidance.
Came upon one glitch: I did not see a Shrink button in my version
(4.1.2) of AOO on the right of the "cell range" box. What I did see,
after setting the Criteria-Allow to "Cell range", is an input line after
a "Source" prom
Reply inline
> On Feb 11, 2016, at 3:35 PM, Vince wrote:
>
>
> TNX Jim for the info; I will give it a try, but would like to be clear about
> how to compose the required reference string and about where to properly
> locate the drop-down selection list .
You can locate it anywhere you find co
TNX Jim for the info; I will give it a try, but would like to be clear
about how to compose the required reference string and about where to
properly locate the drop-down selection list . I will first try with
the selection list definition being located on a sheet within the same
workbook.
First, create the choices that you want to have in the dropdown list: In a
blank spreadsheet,
Go to cell D1. Enter “One”, return; in D2 enter “Two”, return; etc. Let’s say
you do six entries, D1:D6.
Now, select the cell at which you want to make the dropdown list. Let’s use A2.
Now go to
Data
Hello:
Using AOO 4.1.2 on WIN 8.1.
I do not know the correct terminology for searching in HELP file, but I
want to have a drop down selection list, with a clickable arrowhead,
inside a Calc cell. How can this be done?
Regards,
VinceB.
11 matches
Mail list logo