One Button To Execute Two Macros

Question

Previous Topic Next Topic

One Button To Execute Two Macros

[Solved/Closed]

Report

azmiismail

Posts: 17
Registration date: Thursday March 3, 2011
Status: Member
Last seen: July 20, 2011

- Mar 3, 2011 at 01:16 AM
azmiismail

Posts: 17
Registration date: Thursday March 3, 2011
Status: Member
Last seen: July 20, 2011

- Mar 3, 2011 at 11:06 PM

Hello,
I got one macro in Sheet1 and another macro in sheet2 under the same workbook.I want to assign a button in sheet1 so it can execute both the macros in sheet1 and sheet2.Can someone help me....please

Thanks

Assign multiple macros to one button
Assign multiple macros to one button excel - Best answers
How to assign two macros to one button - Best answers
Excel - A macro to record button - How-To - Excel
Combine multiple macros into one ✓ - Forum - Excel
Excel vba assign macro to button programmatically - How-To - Excel
Macro to delete multiple columns based on header ✓ - Forum - Excel
Excel: Sample Macro to Insert Multiple Rows - How-To - Excel

4 replies

Answer 2 / 4

azmiismail

Posts: 17
Registration date: Thursday March 3, 2011
Status: Member
Last seen: July 20, 2011

Mar 3, 2011 at 06:14 PM

Got an error message.To be more specific below are the details,

Under the workbook named "TESTCOMBUTTON"

In Sheet1,the code is,
Sub ClrClls()
Range("B2:B4").ClearContents
End Sub

In Sheet2,the code is,
Sub ClrChks()
ActiveSheet.CheckBoxes.Value=False
End Sub

I would like to assign a button in sheet1 to execute both the code.

Thanks.

Answer 3 / 4

venkat1926

Posts: 1862
Registration date: Sunday June 14, 2009
Status: Contributor
Last seen: July 30, 2015

800
Mar 3, 2011 at 08:12 PM

there is no macro in one sheet and another macro in another sheet. the macros are in one module in vb editor

anyhow try this modification

Sub ClrClls()  
worksheets("sheet1").activate  
Range("B2:B4").ClearContents  
End Sub  


Sub ClrChks()  
worksheets("sheet2").activate  
ActiveSheet.CheckBoxes.Value=False  
End Sub

whenever you talk about error message you musts tell at which statement the error message occurs(or the macro stops) and also the text of error message which will be helpful to try to solve the problem.

Answer 4 / 4

azmiismail

Posts: 17
Registration date: Thursday March 3, 2011
Status: Member
Last seen: July 20, 2011

Mar 3, 2011 at 11:06 PM

Solved,Thank you very much.

Ask a question

venkat1926 · Accepted Answer · 2011-03-03T04:34:55-0500

Answer 1 / 4

venkat1926

Posts: 1862
Registration date: Sunday June 14, 2009
Status: Contributor
Last seen: July 30, 2015

800
Mar 3, 2011 at 04:34 AM

are they macros or event codes depending upon the sheet name. are they macros in the same workbooks create anothermacro

sub fullmacsro
(name of first macro)
(name of second macro)
end usb

make a button and assign "fullmacro" to this button.

One Button To Execute Two Macros

4 replies

Your reply

Subscribe To Our Newsletter!