Hello there,

So this is my first attempt at using VB, besides using record to create a macro, and I am having issues.

I have an ActiveX ComboBox with a list having the values: 25 Stages, 26 Stages, 27 Stages......38 Stages.
I would like for a specific macro to run when I select each option in the combobox. I have recorded these macros and named them Stages_25, Stages_26, so on and so forth.
When I select 25 Stages in the combobox I would like for the macro Stages_25 to run.

Can anyone help me with this?

I right clicked the combobox (ComboBox1) and entered this in to try to see if I can get the first one to run;


Private Sub ComboBox1_Change()
Select Case ComboBox1.Value
Case "25%Stages"
Call Stages_25
End Select

End Sub


Keep in mind I am completely virgin to VB, Thanks!!

Josh