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

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

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

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