ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Retrieving stored names of drop down lists (https://www.excelbanter.com/new-users-excel/250900-retrieving-stored-names-drop-down-lists.html)

mz

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

Rich/rerat

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




All times are GMT +1. The time now is 06:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com