Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Userforms | Excel Discussion (Misc queries) | |||
how to see only youre userforms?? | Excel Discussion (Misc queries) | |||
Userforms & Pocket PC | Excel Discussion (Misc queries) | |||
Open Userforms from a Dropdown list | Excel Discussion (Misc queries) | |||
Controlling excel chart axis | Charts and Charting in Excel |