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
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
Make a third Macro, which in turn is calling the first and the second, and assign the third macro to the button?
 
Upvote 0
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.....
 
Upvote 0
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.
 
Upvote 0
Call the 2nd macro from the 1st macro once it's finished the copying etc.
 
Upvote 0

Forum statistics

Threads
1,213,558
Messages
6,114,296
Members
448,564
Latest member
ED38

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
Back
Top