On Sep 25, 7:36*am, Dave Peterson wrote:
Maybe you can just display a builtin dialog:

Application.Dialogs(xlDialogPrinterSetup).Show



VoxBox-Richard wrote:

Hello,

I have set options using VBA and form inputs allowing users of my spread
sheet to select different groups of sheets and to allow scaling to different
paper sizes.

I would like them to be able to select to printer using an option box – but
I’m not sure how to create a list that will update as different users with
different printers use the spread sheet.

Please can some one point me in the right direction?

Thank you.

Richard

--

Dave Peterson

Full Color Brochures are the core of any marketing campaign. We offer
Color Brochures cheaper than any printing company on the planet! Need
specialty services? We offer folding, collating, binding, and more.
http://www.2theprinter.com/full_colo...59f80e017e2c80