Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
list box using defined name
I went through the directions for creating a "named" list (went to
insert-name-define-added cells-clicked add-clicked close) I named my list "testname" I go to the cell I want to be a list box, then do the following -data-validation-allow list-type "=testname" - click ok I get an error message, is there something I'm doing wrong? |
#2
|
|||
|
|||
Hi
the way i do it in data validation is data / validation / allow = list, click in the source line and press F3, this displays the list of names, i then choose the one i want and excel does the = and " or whatever else it needs. if that doesn't work, test your range, by going to the name box (left of formula bar) and clicking on the drop down arrow ..does your range get selected correctly? -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Jamesmor" wrote in message ... I went through the directions for creating a "named" list (went to insert-name-define-added cells-clicked add-clicked close) I named my list "testname" I go to the cell I want to be a list box, then do the following -data-validation-allow list-type "=testname" - click ok I get an error message, is there something I'm doing wrong? |
#3
|
|||
|
|||
Did you really type the double quotes? If yes, try it without those quotation
marks. Jamesmor wrote: I went through the directions for creating a "named" list (went to insert-name-define-added cells-clicked add-clicked close) I named my list "testname" I go to the cell I want to be a list box, then do the following -data-validation-allow list-type "=testname" - click ok I get an error message, is there something I'm doing wrong? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
loop trough e-mail address list to send task lists with outlook | Excel Discussion (Misc queries) | |||
LOOP - Adddress List -to email | Excel Discussion (Misc queries) | |||
Refresh a Validation List? | Excel Discussion (Misc queries) | |||
Add same set of formulae at defined intervals to list of row data | Excel Worksheet Functions | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) |