About Us

Thanks. This is great. Best wishes.

-----Original Message-----
Below I am using the value of the Cell Link to trigger
the
choice of which Macro to run:

Sub DropDown1_Change()

Select Case Sheets("Sheet1").Range("LinkedCell").Value
Case 1
Call Macro1
Case 2
Call Macro2
Case 3
Call Macro3
End Select

End Sub

Sub Macro1()

MsgBox "This is 1"

End Sub

Sub Macro2()

MsgBox "This is 2"

End Sub

Sub Macro3()

MsgBox "This is 3"

End Sub

-----Original Message-----
Hi All,

I have a combobox from the Form toolbar embeded on a
worksheet. The combobox contains 3 items. I want to
assign
a seperate macro to each of these items. The macros are
ready. How can I assign them?

Thanks for your help.

Regards
.

.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
fill combobox depending on selection from another combobox	Adam Francis	Excel Discussion (Misc queries)	2	July 24th 08 07:39 PM
COMBOBOX	Fernando Duran	Excel Programming	1	February 26th 04 05:32 PM
VBA ComboBox	Stromma	Excel Programming	2	February 23rd 04 11:22 PM
Go To combobox	gregork	Excel Programming	4	February 19th 04 09:11 AM
ComboBox	Michelle Bryant	Excel Programming	2	October 3rd 03 03:13 PM

Menu

About Us