Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 30
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,124
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 macros - how to merge 5 macros together into one Sue Excel Discussion (Misc queries) 1 April 16th 08 08:36 PM
Macros warning always shows up, even if all macros removed Joe M Excel Discussion (Misc queries) 1 December 20th 07 04:45 AM
Create buttom that saves current file in a given filename (Excel) mamealemka Excel Worksheet Functions 3 March 17th 06 12:02 PM
Training: More on how to use macros in Excel: Recording Macros ToriT Excel Worksheet Functions 2 February 10th 06 07:05 PM
How do I add command buttom? rgarber50 Excel Discussion (Misc queries) 1 July 11th 05 03:39 AM


All times are GMT +1. The time now is 03:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"