Getting printers list to put in userform

G

Guest

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?
 
J

Jim Cone

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


"sciteach"
<[email protected]>
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Listbox to display ALL Available Printers to User on a Userfrom 2
Userform to Select what worksheets to print 1
userform list setup 1
Userform Listbox selection change 2
Print a Userform To Fit On One Page 3
Populate Listbox on Userform with file names 1
Listing Printers in Excel 10
Userform textbox string to header causes unwanted double spacing 4

Top