Choose which Macro to run

[kadoyla]

Hi,

I am new to VBA, and have written some simple code that pulls some information out of a SharePoint 2010 list view, and makes some simple calculations within an Excel 2010 table. I have then written a number of individual subs that use the table to prepare a single Pivot Table each. The Pivot Tables are used for adhoc reporting and so I never need more than one Pivot table as I copy it out into an email.

Each of these individual elements works fine, but I would like the first macro, PopulateData(), to prepare the table and then pop up a window which asks which Pivot Table I would like (MissedDeadline(), Overdue() etc), upon selection it would then run the chosen macro and present the pivot table.

Any help would be greatly appreciated.

Kind Regards,

Simon

 

[Soggy]

I had a similar situation where I had to change the report depending on which department was looking at it.

I found that creating a userform to pop up when opening the spreadsheet (for you you will call it a the end of your populate data macro). Depending on selection the relevant macro will run. You can have a selection list or tick boxes depends on your preference.

Hope this helps.

 

[kadoyla]

I hadn't even thought of that! Nice and simple, thank you Soggy!