Hi, i'm a new user of Macros/VBA and altho i'm slowly improving (mainly
thanks to theadvice on this forum!) i find myself stuck once again!

I want to create a macro that will open a user form which instructs the
user to enter their name, the date and the subject in three seperate
boxes.

On clicking ok, a second form pops up asking the users to click on the
macro they wish to run, eg macro 1, macro 2, macro 3 etc (these macros
are already written and working fine!)

When these macros are run they will bring up a template (which i have
created using macro recorder) - I would like the template to show the
information the user entered in the first form - eg, the name will be
entered in a1, the date in a2, the subject in a3.

Ideally i would like the user to be able to select as many of the
macros they wish to run and when they click ok have each of the
selected macros run in turn (as ultimately the aim is to allow the user
to create a customised workbook from a range of recorded templates.)

Is this, or something like this, possible? Can anyone explain how i
should do it or point me in the right direction? Your help is much
appreciated.


---
Message posted from http://www.ExcelForum.com/