Modify "pick from list" to read named range

[N E Body]

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]

You can use data validation to create drop down lists in cells. There
are instructions in Excel's Help, and here:

http://www.contextures.com/xlDataVal01.html

 

[N E Body]

Many many thanks Debra

DataValCode is exactly what I needed

Thanks for a brilliant site!

Kenny

 

[Debra Dalgleish]

You're welcome! Thanks for letting me know that it helped.