2 Macros 1 Buttom

  • Thread starter Thread starter Sudipta Sen
  • Start date Start date
S

Sudipta Sen

Want to use 2 macros by useing 1 buttoms,

Means I create a buttoms to use a macro function, but I want to use same
buttoms for 2 or more macro functions.

How could I do it.
With loves to all my freinds.
Sudipta
 
Hi,

Maybe like this

Sub Button1_Click()
Call MySub
Call MySub1
End Sub

Sub MySub()
MsgBox "Mysub"
End Sub

Sub MySub1()
MsgBox "Mysub1"
End Sub

Mike
 
If? you want to run 2 or more macros just use
run macro 1
run macro 2
etc
==
if you want to choose, use a dropdown linked to a worksheet change event
that fires the macro desired depending on choice
???
 
Back
Top