Hi,
I'm creating a measurment document were I would like to have several combined ComboBoxes and then send that information to another workbook. I've done this with Data Validation Lists, but I got more then 8 choises and it's a pain to work with a scroll-list.
I've been able to combine the ComboBoxes with below code, but I haven't figure out how to send that information when they acctualy dosen't in a specific cell. I've tried to select the range my ComboBoxes are placed in but that didn't help me out at all.
Private Sub ComboBox1_Change()
If ComboBox1 = "A" Then ComboBox2.ListFillRange = "Sheet2!B2:B30"
If ComboBox1 = "B" Then ComboBox2.ListFillRange = "Sheet2!C2:C30"
End Sub
Thanks!
I'm creating a measurment document were I would like to have several combined ComboBoxes and then send that information to another workbook. I've done this with Data Validation Lists, but I got more then 8 choises and it's a pain to work with a scroll-list.
I've been able to combine the ComboBoxes with below code, but I haven't figure out how to send that information when they acctualy dosen't in a specific cell. I've tried to select the range my ComboBoxes are placed in but that didn't help me out at all.
Private Sub ComboBox1_Change()
If ComboBox1 = "A" Then ComboBox2.ListFillRange = "Sheet2!B2:B30"
If ComboBox1 = "B" Then ComboBox2.ListFillRange = "Sheet2!C2:C30"
End Sub
Thanks!
