Solved: Macro Calling

[blastpwr1970]

Hi all,

Is it possible to call a macro with the individual entries on a combobox by selecting the different texts in the list, assigning one macro per line of text.

Something like if "text1" then call macro1, if "text2" then call macro2 etc...

I am still learning so, if you could post an example that would be great.

Thank you for all of your help, you all been great.

[Bob Phillips]

[vba]

Select Case Combobox1.Value
Case "text1: Call Macro1
Case "text2": Call Macro2
'etc
End Select
[/vba]

[blastpwr1970]

Thanks is working great.