| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modify "pick from list" to read named range
Hello everyone
When I right click and select "Pick from list" I get a selection to choose from. Is it possible to modify or emulate this to select a named range? Kenny Win Me 2000 and XP Office 97 and 2000 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Modify "pick from list" to read named range
You can use data validation to create drop down lists in cells. There
are instructions in Excel's Help, and he http://www.contextures.com/xlDataVal01.html N E Body wrote: Hello everyone When I right click and select "Pick from list" I get a selection to choose from. Is it possible to modify or emulate this to select a named range? Kenny Win Me 2000 and XP Office 97 and 2000 -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Modify "pick from list" to read named range
Many many thanks Debra
DataValCode is exactly what I needed Thanks for a brilliant site! Kenny "Debra Dalgleish" wrote in message ... You can use data validation to create drop down lists in cells. There are instructions in Excel's Help, and he http://www.contextures.com/xlDataVal01.html N E Body wrote: Hello everyone When I right click and select "Pick from list" I get a selection to choose from. Is it possible to modify or emulate this to select a named range? Kenny Win Me 2000 and XP Office 97 and 2000 -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Modify "pick from list" to read named range
You're welcome! Thanks for letting me know that it helped.
N E Body wrote: Many many thanks Debra DataValCode is exactly what I needed Thanks for a brilliant site! Kenny "Debra Dalgleish" wrote in message ... You can use data validation to create drop down lists in cells. There are instructions in Excel's Help, and he http://www.contextures.com/xlDataVal01.html N E Body wrote: Hello everyone When I right click and select "Pick from list" I get a selection to choose from. Is it possible to modify or emulate this to select a named range? Kenny Win Me 2000 and XP Office 97 and 2000 -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combining values and text to make a reference for "named range" | Excel Worksheet Functions | |||
| Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
| How can I use a named range for "pick from drop-down list"? | Excel Discussion (Misc queries) | |||
| Adding named range gives error "method range of object _Global failed " | Excel Programming | |||
| SQL "INSERT INTO" Does not Modify Definition of Target Range | Excel Programming | |||
Linear Mode
