Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form Question
Hi there
I need to implement a user form that let's the user pick one of five cases (basic, increased, decreased, superior, inferior) and when each is picked, it runs a macro that changes specific cells. I have all the macros recorded and saved, I am just clueless as to how to get the list inside of the combo box and then have the macros executed. Any help would be greatly appreciated! Thank you |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form Question
Hi Alex,
Try something like: '============= Private Sub ComboBox1_Change() Select Case Me.ComboBox1.Value Case "basic": Call Macro1 Case "increased": Call Macro2 Case "decreased": Call Macro3 Case "superior": Call Macro4 Case "inferior": Call Macro5 End Select End Sub '------------------ Private Sub UserForm_Initialize() With Me.ComboBox1 .AddItem "basic" .AddItem "increased" .AddItem "decreased" .AddItem "superior" .AddItem "inferior" End With End Sub '<<============= --- Regards, Norman wrote in message ups.com... Hi there I need to implement a user form that let's the user pick one of five cases (basic, increased, decreased, superior, inferior) and when each is picked, it runs a macro that changes specific cells. I have all the macros recorded and saved, I am just clueless as to how to get the list inside of the combo box and then have the macros executed. Any help would be greatly appreciated! Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Form question | Excel Discussion (Misc queries) | |||
User Form question | Excel Programming | |||
user form question | Excel Programming | |||
User Form Question | Excel Programming | |||
User Form Question | Excel Programming |