Hi Andy,

Could someone please offer me an example of how I might achieve the
following Message/Input box in Excel and use the selections later on in
my macro:

Document Options

E-Mail Required Yes/No
E-Mail Address
Fax Required Yes/No
Fax Number
Printout Required Yes/No
Destination Printer \\example1\example1 on 1
\\example2\example2 on 2
\\example3\example3 on 3



I think that a Userform would be a much better option.


Be kind - I am new to VBA and I am jumping straight in over my depth.

Debra Dalgleish has a very user-friendly tutorial at:

http://www.contextures.com/xlUserForm01.html

As you are new to VBA, you may wish to visit David McRitchie's 'Getting
Started With Macros And User Defined Functions' at:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

You might also look at David's tutorials page at:

http://www.mvps.org/dmcritchie/excel....htm#tutorials

The VBA material is towards the bottom of the tutorials section.


---
Regards,
Norman



"AndyGFLees" wrote
in message ...

Could someone please offer me an example of how I might achieve the
following Message/Input box in Excel and use the selections later on in
my macro:

Document Options

E-Mail Required Yes/No
E-Mail Address
Fax Required Yes/No
Fax Number
Printout Required Yes/No
Destination Printer \\example1\example1 on 1
\\example2\example2 on 2
\\example3\example3 on 3





Be kind - I am new to VBA and I am jumping straight in over my depth.


--
AndyGFLees
------------------------------------------------------------------------
AndyGFLees's Profile:
http://www.excelforum.com/member.php...o&userid=29536
View this thread: http://www.excelforum.com/showthread...hreadid=492354