ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   2 Macros 1 Buttom (https://www.excelbanter.com/excel-worksheet-functions/250959-2-macros-1-buttom.html)

Sudipta Sen[_2_]

2 Macros 1 Buttom
 
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

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


Don Guillett

2 Macros 1 Buttom
 
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
???

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sudipta Sen" wrote in message
...
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




All times are GMT +1. The time now is 04:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com