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

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