Thread: Combobox
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
K Dales K Dales is offline
external usenet poster
 
Posts: 131
Default Combobox

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
.