How to: Create Dependent Drop Down in a Form

B

Benjamin

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
 
B

Benjamin

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop Down with dynamic named range offsheet source list 14
How to create 2 dependent drop down lists from 1 original drop dow 5
Dependent drop down dynamic range formula, off sheet. 7
multiple dependent drop down lists 6
Create a Drop down List on a Form 2
dependent drop down list 1
How can you link or have various drop down fileds be dependent on. 1
Define the Range of a drop-down list 5

Top