Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 23rd 08, 08:07 PM posted to microsoft.public.excel.misc
Amy Amy is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 165
Default Drop down list based on choice of another dropdown

A1 has a list of 4 choices
AAA
BBB
CCC
DDD
Depending on which of these I choose, I want to have te ability to choose
from another list that is associated with my first choce. How can I do this?

  #2   Report Post  
Old January 23rd 08, 08:22 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,942
Default Drop down list based on choice of another dropdown

hi
if you are using data validations, see this site
http://www.contextures.com/xlDataVal02.html

or if you are using sheet combo box.

if combobox1.value = "choise1" then
combobox2.rowsource = range1
else
if combobox1.value = "choise2" then
combobox2.rowsource = range2
else
if combobox1.value = "choise3" then
cobobox2.rowsource = range3
end if
end if
end if
the above is pysudo code but the principle is sound.
range1 might be something like range("A1:A5") and so on

the above is good for form combo boxes.

regards
FSt1

"Amy" wrote:

A1 has a list of 4 choices
AAA
BBB
CCC
DDD
Depending on which of these I choose, I want to have te ability to choose
from another list that is associated with my first choce. How can I do this?

  #3   Report Post  
Old January 23rd 08, 08:39 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,907
Default Drop down list based on choice of another dropdown

Dependent DV list instructions from Debra's site.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP


On Wed, 23 Jan 2008 12:07:00 -0800, Amy wrote:

A1 has a list of 4 choices
AAA
BBB
CCC
DDD
Depending on which of these I choose, I want to have te ability to choose
from another list that is associated with my first choce. How can I do this?




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
Multiple choice in dropdown list Augusta Excel Discussion (Misc queries) 1 October 19th 07 10:16 AM
Sorting based on Drop Down choice [email protected] Excel Discussion (Misc queries) 5 March 23rd 07 07:58 PM
Drop Down List choice selecting another drop down list CVD0722 Excel Worksheet Functions 3 October 31st 06 01:02 PM
drop-down list changing according to choice made choc_penguin Excel Worksheet Functions 1 January 4th 06 06:26 PM
Dropdown list/Multiple choice?? KDD Excel Discussion (Misc queries) 2 August 30th 05 09:28 AM


All times are GMT +1. The time now is 03:37 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017