VBA - Call 2 Subs

[Vampy99]

Hi,

I have a spreadsheet which is a user report, users choose a date from a UserForm & click a button, then the report populates excel with some data for that date.

After choosing the date the click a button on the UserForm which runs "Sub PopulateDetails".

On the output sheet there is another button which isn't always pressed, it's more for extra bits of info. For this I have another procedure called "Sub CalculateProjections". To get accurate information I need the first Sub to run before this one, without merging the 2 subs in to one is there a way to call one Sub inside another or create something that will run one Sub & then run another?

Thanks,

Luke

 

[Joe4]

To call one macro from another, simply use "Call" and the macro name, i.e.
http://www.mrexcel.com/archive/VBA/17641.html