LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lorena
 
Posts: n/a
Default Drop Down Menu - dependencies

I have a spreadsheet that I've created all the necessary naming for the
various drop-down menus. However, I cannot get a cell (that depends on a
choice in one column) to go blank to force the user to make a selection from
the new group of selections.

Example: Column A I choose Cat, B - I get choices of colors (brown, gray,
etc.)
If I choose Column A to be Snake, I want be to go blank, and then the new
selections be ready in the pull down area (green, yellow, etc.)

Is this possible?
--
Lori DeMoss
HP Administrator
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Edit Menu will not automatically drop down anymore Irene Pai Excel Discussion (Misc queries) 5 May 12th 11 07:43 AM
hyperlinks in drop down menu MikeyB Excel Worksheet Functions 0 November 22nd 05 03:49 PM
hyperlinks in drop down menu MikeyB Excel Worksheet Functions 0 November 22nd 05 03:48 PM
Help with drop down menu Jrr6415sun Excel Worksheet Functions 4 July 10th 05 05:58 PM
How do I set up a drop down menu within a drop down menu? Rob Excel Discussion (Misc queries) 1 April 12th 05 06:02 PM


All times are GMT +1. The time now is 02:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"