Thread: Modify "pick from list" to read named range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
  
Posts: 2,979
Default 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

Reply With QuoteReply With Quote