I use a userform to select what reports to print and want to incorporate an
added feature where I can change the active printer. Currently, I go to
file-print, choose the printer (to change the active printer), cancel out of
the printer dialog and then run the userform. I have also previously
manually entered all the printers into the form listbox. This worked until I
added a printer and all my entries needed to be changed. I am sure there is
an easier way.
How can I pull a list of printers on my computer to show up in a listbox?

There is a built-in list available...
Application.Dialogs(xlDialogPrinterSetup).Show
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"sciteach"

wrote in message
I use a userform to select what reports to print and want to incorporate an
added feature where I can change the active printer. Currently, I go to
file-print, choose the printer (to change the active printer), cancel out of
the printer dialog and then run the userform. I have also previously
manually entered all the printers into the form listbox. This worked until I
added a printer and all my entries needed to be changed. I am sure there is
an easier way.
How can I pull a list of printers on my computer to show up in a listbox?