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) |