View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 2 Macros 1 Buttom

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

"Sudipta Sen" wrote:

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