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

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 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

Many many thanks Debra

DataValCode is exactly what I needed

Thanks for a brilliant site!

Kenny


"Debra Dalgleish" <dsd@contexturesXSPAM.com> wrote in message
news:41FADD54.7000206@contexturesXSPAM.com...
> 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 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
>

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" <dsd@contexturesXSPAM.com> wrote in message
> news:41FADD54.7000206@contexturesXSPAM.com...
>
>>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 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