Reply inline
On Feb 11, 2016, at 3:35 PM, Vince <[email protected]> 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 convenient. I’d suggest that you put it on
another sheet, but you don’t have to.
I will first try with the selection list definition being located on a sheet within the
same workbook. I could name that sheet "Selection Lists" and write a reference
string to that.
I would pick a short name. If you put a space in the title, it has to be quoted
when you reference it. Just call it “Lists,” or something like that. If you’ll
use the shrink button as I said, you don’t have to “write” any references. It’s
all done for you. You just select the range of the cells in which the choices
appear. But you can write it if you want to: $Lists.$A$1:$A$5 will work just as
well as selecting with the shrink button, and it works just as well.
All those $’s hold the reference in one spot. They’re called “Absolute
references.”
I have not ever tried to write a reference string to a sheet that is located
within a separate Workbook file, and do not know if that is possible to work.
Well, you *can* put the list in a separate workbook, but both workbooks have to
be open for the reference to work. Just keep it in the same workbook, but on a
different sheet. Sheets are selected with the tabs at the bottom of the window
where it says “Sheet1”, “Sheet2”, and “Sheet3.” You can add more sheets if you
need them, and you can change the names. Right-click on the sheet tab to bring
up a context menu that will allow you to change the sheet name. ***If you’re
going to do that, though, do it before you create your reference list.
At this point, my selection list must include the following that I plan to do
logic operations on from another sheet:
* With Vets '16
* With George '16
* During '16 BVL Practice
* During '16 BVL Competition
* '16 Practice Alone
List them just the way I told you: One selection per cell, all cells in the
same column.
Those choices are associated with a Workbook where I record my bowling scores
and George's bowling scores, such as they are! In some cases I bowl a 3-game
series whereas in other cases I bowl a 5-game match, and yet when practicing
alone, any number of games may be bowled!.
This isn’t rocket science, and nowhere near as hard as picking up a 7-10 split.
Just give it a try and throw a few gutter balls. We learn best from failure.
Good thing programming doesn’t hurt, or I’d be a wreck.
Regards,
VinceB.
On 2/11/2016 12:18 PM, James Plante wrote:
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->Validity; you’ll get a dialog box. In that box, at the “Allow” prompt,
click the dropdown box and select “Cell Range.” The dialog changes.
On the right of the “cell range” box, select the “shrink” button. Now in the
spreadsheet, select D1 and drag to D6. Hit the shrink button again, and once
again the dialog changes. The selected range of inputs is now $Sheet1.$D$1:$D$6.
Click “OK” and you’re good to go. Cell A2 now has an arrow next to it when it
is selected—and only when selected! Click the arrow, and you can choose any of
the six entries you made in D1:D6.
There are other options available in the dialog. Explore them. You can use
numbers, text, or formulas that give rise to arrays. Read the docs to find out
more about it. (Google is your buddy.)
For instance, if you had a bunch of different cells in which you wanted to
control or expedite data entry, you could put all the selections in different
areas on Sheet2. Then when it’s time to select your cell range, shrink the
dialog, change sheets, select the desired range, hit shrink again, and the
dialog would show something like “$Sheet2.$F$10:$F$15”, and those choices would
populate your target cell.
Jim Plante
On Feb 11, 2016, at 10:56 AM, Vince <[email protected]> wrote:
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.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
