Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to: Create Dependent Drop Down in a Form
I've got two combo boxes in a form.
One is the "Master" and the second is the dependent. I can do this in a regular cell with validation drop-downs. How do I create the dependent in the userform? ----------------------------------------------------------- <<RANGES Master Range =LISTS!$A$2:INDEX(LISTS!$A:$A,COUNTA(LISTS!$A:$A)) UseList Range =INDEX(ValData,1,MATCH('Data Entry'!B75,LISTS!$1:$1,0)): INDEX(ValData,Counter,MATCH('Data Entry'!B75,LISTS!$1:$1,0)) ----------------------------------------- <<VBA <<Current UserForm Initialize code: Private Sub UserForm_Initialize() cboDiscipline = "--Select Here First--" cboDescription = "--Select Here Second--" With Worksheets("LISTS") Me.cboDiscipline.List _ = .Range("Master").Value End With End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to: Create Dependent Drop Down in a Form
Will these work for you?
http://www.contextures.com/xldataval02.html http://www.contextures.com/xlDataVal13.html HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Benjamin" wrote: I've got two combo boxes in a form. One is the "Master" and the second is the dependent. I can do this in a regular cell with validation drop-downs. How do I create the dependent in the userform? ----------------------------------------------------------- <<RANGES Master Range =LISTS!$A$2:INDEX(LISTS!$A:$A,COUNTA(LISTS!$A:$A)) UseList Range =INDEX(ValData,1,MATCH('Data Entry'!B75,LISTS!$1:$1,0)): INDEX(ValData,Counter,MATCH('Data Entry'!B75,LISTS!$1:$1,0)) ----------------------------------------- <<VBA <<Current UserForm Initialize code: Private Sub UserForm_Initialize() cboDiscipline = "--Select Here First--" cboDescription = "--Select Here Second--" With Worksheets("LISTS") Me.cboDiscipline.List _ = .Range("Master").Value End With End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to: Create Dependent Drop Down in a Form
No I need to access combo box 1 's value
and allow that to fit into the combobox two's selection options that use the ..additem "ryguy7272" wrote: Will these work for you? http://www.contextures.com/xldataval02.html http://www.contextures.com/xlDataVal13.html HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Benjamin" wrote: I've got two combo boxes in a form. One is the "Master" and the second is the dependent. I can do this in a regular cell with validation drop-downs. How do I create the dependent in the userform? ----------------------------------------------------------- <<RANGES Master Range =LISTS!$A$2:INDEX(LISTS!$A:$A,COUNTA(LISTS!$A:$A)) UseList Range =INDEX(ValData,1,MATCH('Data Entry'!B75,LISTS!$1:$1,0)): INDEX(ValData,Counter,MATCH('Data Entry'!B75,LISTS!$1:$1,0)) ----------------------------------------- <<VBA <<Current UserForm Initialize code: Private Sub UserForm_Initialize() cboDiscipline = "--Select Here First--" cboDescription = "--Select Here Second--" With Worksheets("LISTS") Me.cboDiscipline.List _ = .Range("Master").Value End With End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create 2 dependent drop down lists from 1 original drop dow | Excel Discussion (Misc queries) | |||
How do I create drop down form fields in Excel? | Excel Discussion (Misc queries) | |||
Create a list in a drop down dependent upon another dd list in exc | Excel Discussion (Misc queries) | |||
Create a drop down list dependent on selection from another list | Excel Programming | |||
How do I create a form with drop downs that narrows choices? | Excel Discussion (Misc queries) |