PDA

View Full Version : Solved: Macro Calling



blastpwr1970
12-17-2006, 04:44 PM
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
12-17-2006, 05:13 PM
Select Case Combobox1.Value
Case "text1: Call Macro1
Case "text2": Call Macro2
'etc
End Select

blastpwr1970
12-19-2006, 10:49 AM
Thanks is working great.