Context Sensitive Drop Down Menus

's Computer Specifications

I need to be able to specify drop down menus that depend on the selections
made in other menus. For example, I will specify in cell A1 the choice
between dog and tree. If the user picks dog then I want the selections in
cell B1 to be beagle and hound. If the user picks tree in A1 then I want
the choices in B1 to be oak and pine. I think you get my drift. It isn't
clear to me how to set this up. Any help would be appreciated. Thanks in
advance.

's Computer Specifications

You're describing Dependent Lists.

See Debra Dalgleish's coverage of them at her website:
http://www.contextures.com/xlDataVal02.html

Does that help?
(Post back with more questions.)
***********
Regards,
Ron

XL2002, WinXP

"Sam Bench" wrote:

> I need to be able to specify drop down menus that depend on the selections
> made in other menus. For example, I will specify in cell A1 the choice
> between dog and tree. If the user picks dog then I want the selections in
> cell B1 to be beagle and hound. If the user picks tree in A1 then I want
> the choices in B1 to be oak and pine. I think you get my drift. It isn't
> clear to me how to set this up. Any help would be appreciated. Thanks in
> advance.
>
>
>

's Computer Specifications

Thanks, Ron. Just what I was looking for.

"Ron Coderre" <(E-Mail Removed)> wrote in message
news:20AC68BE-32A7-4BB0-BA44-(E-Mail Removed)...
> You're describing Dependent Lists.
>
> See Debra Dalgleish's coverage of them at her website:
> http://www.contextures.com/xlDataVal02.html
>
> Does that help?
> (Post back with more questions.)
> ***********
> Regards,
> Ron
>
> XL2002, WinXP
>
>
> "Sam Bench" wrote:
>
>> I need to be able to specify drop down menus that depend on the
>> selections
>> made in other menus. For example, I will specify in cell A1 the choice
>> between dog and tree. If the user picks dog then I want the selections
>> in
>> cell B1 to be beagle and hound. If the user picks tree in A1 then I want
>> the choices in B1 to be oak and pine. I think you get my drift. It
>> isn't
>> clear to me how to set this up. Any help would be appreciated. Thanks
>> in
>> advance.
>>
>>
>>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Overly sensitive drag and drop context menu in 2007	dedawson	Microsoft Powerpoint	5	21st Jan 2010 03:46 PM
Access2007 Context-sensitive menus	Wierdbeard65	Microsoft Access VBA Modules	0	15th Nov 2009 04:41 PM
Context Sensitive Web Menus in ASP.NET	Kayhan	Microsoft ASP .NET	1	29th Mar 2004 08:11 PM
No context sensitive drop down menu - help needed.	Chris Mitchell	Microsoft Outlook	0	13th Mar 2004 05:37 AM
Context menus and treeviews, suggestions for a NODE sensitive context menu	Eric Newton	Microsoft Dot NET Framework Forms	4	13th Jan 2004 09:25 PM