Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 18th 09, 08:41 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2009
Posts: 35
Default dependent drop down list

I know that you can create a list (i.e. Produce - Fruits, Vegetables, etc.)
and then a dependent list (i.e. Fruits -Apples, Oranges, etc.). But you have
to use two columns. For example, column A is data validated for the Produce
list and you choose Fruit. Then column B is data validated for the dependent
lists where you can choose Apple.

Is there anyway to do this without the use of column B and have everything
on column A? So basically, in column A, you would put your cursor over Fruit
in the drop down list and then a second drop down list would appear to the
right side of the drop down list and you can choose Apple and this would be
the selection in column A.


  #2   Report Post  
Old December 18th 09, 10:36 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2008
Posts: 1,071
Default dependent drop down list

Not the way you describe. You can use VBA programming so that after you
select Fruit in the column A cell drop-down, the cell would clear and
another drop-down would be available in the same cell. You click that
drop-down arrow and it would display some fruits from which you can select
Apple. Does this sound like what you want? HTH Otto

"yowzers" wrote in message
...
I know that you can create a list (i.e. Produce - Fruits, Vegetables,
etc.)
and then a dependent list (i.e. Fruits -Apples, Oranges, etc.). But you
have
to use two columns. For example, column A is data validated for the
Produce
list and you choose Fruit. Then column B is data validated for the
dependent
lists where you can choose Apple.

Is there anyway to do this without the use of column B and have everything
on column A? So basically, in column A, you would put your cursor over
Fruit
in the drop down list and then a second drop down list would appear to the
right side of the drop down list and you can choose Apple and this would
be
the selection in column A.



Reply
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
DEPENDENT DROP DOWN LIST SSJ New Users to Excel 1 March 25th 08 12:56 AM
Drop down list options dependent on cell value mt Excel Discussion (Misc queries) 2 March 12th 08 09:59 PM
Create a list in a drop down dependent upon another dd list in exc fyrefox Excel Discussion (Misc queries) 1 August 9th 07 08:46 PM
Need to creat dependent drop down list manu Excel Worksheet Functions 2 July 26th 07 11:59 AM
Dependent drop-down list?? DocBrown Excel Worksheet Functions 4 July 21st 06 01:55 AM


All times are GMT +1. The time now is 01:06 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017