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?