Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
controlling a form drop down based on selection of another drop down
I've got a form that has a selection of drop downs - I'd like one of the drop down later on in the form to be controlled by what a user selects in the first drop down - e.g. the first drop down has A, B, C, D, E to select from - if they select A I'd like the later drop down to show certain list, if they select B I'd like it to show a different list and so on. Is this possible? Many, many thanks as ever! -- flurry ------------------------------------------------------------------------ flurry's Profile: http://www.excelforum.com/member.php...o&userid=34303 View this thread: http://www.excelforum.com/showthread...hreadid=548596 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
controlling a form drop down based on selection of another drop down
If you have a dynamic range in the workbook, whose size relates to the value of the first combobox e.g. on Sheet1 column A|column B A Ai A Aii A Aiii B Bi B Bii C Ci C Cii C Ciii etc whatever... and C1 is linked to CombBox1.ControlSource with a named range "MyRange" =OFFSET(Sheet1!$B$1,MATCH(Sheet1!$C$1,Sheet1!$A:$A ,0)-1,0,COUNTIF(Sheet1!$A:$A,Sheet1!$C$1),1) Then put something like this in the the _enter event of ComboBox2 or _exit event of ComboBox1 ComboBox2.Clear if thisworkbook.sheets("Sheet1").range("C1").value<e mpty then for each c in thisworkbook.sheets("Sheet1").range("MyRange") ComboBox2.additem (c.value) next You'll probably need to tweak it a little... Col -- colofnature ------------------------------------------------------------------------ colofnature's Profile: http://www.excelforum.com/member.php...o&userid=34356 View this thread: http://www.excelforum.com/showthread...hreadid=548596 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell value based on selection from drop box | Excel Worksheet Functions | |||
count based on selection from drop down list | Excel Worksheet Functions | |||
Hide row(s) based on drop down selection | Excel Discussion (Misc queries) | |||
Change row colour based on the drop down selection | Excel Discussion (Misc queries) | |||
Drop Down Lists - assign a value based on selection | Excel Worksheet Functions |