| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Retrieving stored names of drop down lists
How can I retreive existing names of a drop down lists that I have created.
The validation box requires you to type an equal sign followed by the name. What do you do if you forget the name? -- MZ |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Retrieving stored names of drop down lists
MZ,
If the range name is located in the workbook, you should find it under: Insert Name Define Known Lists in Workbook will show. If the range name is in another workbook, then you will need to search through them to fine its location. -- Add MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) <message rule <<Previous Text Snipped to Save Bandwidth When Appropriate "MZ" wrote in message ... How can I retreive existing names of a drop down lists that I have created. The validation box requires you to type an equal sign followed by the name. What do you do if you forget the name? -- MZ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filesize: embedded data validation lists all stored independently? | Excel Discussion (Misc queries) | |||
| names and drop down lists | Excel Worksheet Functions | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
| Problem Code: Retrieving Stored Access 03 Query | Excel Discussion (Misc queries) | |||
Linear Mode
