Can a Form Control Button activate two macros?

S_Coupland

Board Regular
Joined
May 14, 2012
Messages
64
Hi Good Day to all,

This is stricktly a question (for Now) :)

if i create a form control button, can that single button exicute two macros? the first macro would be to export data from selected cells .... example ....

i would like all the data from cels B6, E6, H6 and I6 to be exported to another worksheet on another workbook.

the second function of the same button would act as a hyperlink to the worksheet within the workbook where the data has just been copied.

Really looking forward to your replies.....

Many Thanks

Regards

Simon
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Mindpsyche

Well-known Member
Joined
Mar 19, 2012
Messages
760
Make a third Macro, which in turn is calling the first and the second, and assign the third macro to the button?
 

S_Coupland

Board Regular
Joined
May 14, 2012
Messages
64
Hi Mindpsyche,

Ahhhhhhhhh......... i see where you are going....... hadnt thought of that...... defo worth concidering....

Thank You for the Brand New Insight and Train of Thought.....
 

Mindpsyche

Well-known Member
Joined
Mar 19, 2012
Messages
760
No worries, just make sure that when you call both macros, after running the first macro, the sheet is exactly as it should be before you run the 2nd macro.
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,274
Office Version
  1. 365
Platform
  1. Windows
Call the 2nd macro from the 1st macro once it's finished the copying etc.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,872
Messages
5,627,389
Members
416,245
Latest member
Xterminat

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top