View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
harrysfan harrysfan is offline
external usenet poster
 
Posts: 1
Default 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.