Controlling Userforms
 

I have designed a userform which produces a combobox(1) - list of items
from which an item can be selected. Based on this selection another
combobox(2) is produced and displayed on the userform with an item list
from which another item can be selected.

when an item is selected from this combobox(2) I need to be able to
show another userform based on the selected item eg.

TYPE1
TYPE2
TYPE3
TYPE4

I have designed the (secondary) userforms (and called them type1 -
type4) but cannot get them to display based on the selection made in
combobox(2)

Can anyone help please.

Controlling Userforms
 

Select Case Combobox2.Value
Case 1: TYPE1.Show
Case 2: TYPE2.SHow
'etc.
End Select

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"harrysfan" wrote in message
oups.com...
I have designed a userform which produces a combobox(1) - list of items
from which an item can be selected. Based on this selection another
combobox(2) is produced and displayed on the userform with an item list
from which another item can be selected.

when an item is selected from this combobox(2) I need to be able to
show another userform based on the selected item eg.

TYPE1
TYPE2
TYPE3
TYPE4

I have designed the (secondary) userforms (and called them type1 -
type4) but cannot get them to display based on the selection made in
combobox(2)

Can anyone help please.