2 Macros 1 Buttom

[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

 

[Mike H]

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

 

[Don Guillett]

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
???