S
samanco
I have two ComboBoxes on a VBA Userform, what I want is for users to
select a major Catagory from combobox1, which then changes the list
value in ComboBox2. I use named ranges on a hidden worksheet which
contrains lists of constants. I cannot get combobox 2 to recognise
the value of ComboBox 1 as the name of a valid list ??
I have tried a number of methods, such as:
If ComboBox 1 value = "Prada" then
ComboBox2.RowScource = "Shoes"
else if ComboBox 1 value = "Vesace" then
ComboBox2.RowScource = "suits"
end if
etc
and the Select Case method
i,e.
Select case_designer
case 1 = prada
case 2 = versace
etc
however try and try again I cannot get this to work
has any one got any working sub that I can have a look at as an
example please?
select a major Catagory from combobox1, which then changes the list
value in ComboBox2. I use named ranges on a hidden worksheet which
contrains lists of constants. I cannot get combobox 2 to recognise
the value of ComboBox 1 as the name of a valid list ??
I have tried a number of methods, such as:
If ComboBox 1 value = "Prada" then
ComboBox2.RowScource = "Shoes"
else if ComboBox 1 value = "Vesace" then
ComboBox2.RowScource = "suits"
end if
etc
and the Select Case method
i,e.
Select case_designer
case 1 = prada
case 2 = versace
etc
however try and try again I cannot get this to work
has any one got any working sub that I can have a look at as an
example please?