cavemonkey
07-13-2008, 07:24 PM
Hi
I need to come up with a userform using combo boxes.
I have
cmb1: 1 2 3
cmb2: 1.1 2.1 3.1
1.2 2.2 3.2
1.3 2.3 3.3
I have 2 combo boxes.
how do i make sure that if i click 1 on cmb1, i will get the options 1.1/1.2/1.3 in cmb2. and likewise for 2 in cmb1, i will get options 2.1/2.2/2.3 in cmb2? I've defined Name for 1.1/1.2/1.3, 2.1/2.2/2.3 etc already. So how i can link the option in cmb1 to make it recognize the Name i've defined and make it the RowSource for the cmb2??
But the all the options in cmb2 acutally represent different spreadsheets in the excel file.
Pls advise. Thanks.
I need to come up with a userform using combo boxes.
I have
cmb1: 1 2 3
cmb2: 1.1 2.1 3.1
1.2 2.2 3.2
1.3 2.3 3.3
I have 2 combo boxes.
how do i make sure that if i click 1 on cmb1, i will get the options 1.1/1.2/1.3 in cmb2. and likewise for 2 in cmb1, i will get options 2.1/2.2/2.3 in cmb2? I've defined Name for 1.1/1.2/1.3, 2.1/2.2/2.3 etc already. So how i can link the option in cmb1 to make it recognize the Name i've defined and make it the RowSource for the cmb2??
But the all the options in cmb2 acutally represent different spreadsheets in the excel file.
Pls advise. Thanks.