COMBOBOX WITH PRINTERS LIST
 

Hi everyone!
I built a Form that prepares the layout of 22 sheets, but
then I would like to print them (on my PC I go on the
default printer) but i need to show the end-user the list
of printers that he has on his computer, therefore I
wanted to create a combobox with this list.

Thank you in advance!

Chris

COMBOBOX WITH PRINTERS LIST
 

How about just popping up the printer setup dialog?

Application.Dialogs(xlDialogPrinterSetup).Show

or

Application.Dialogs(xlDialogPrint).Show

or if you really want to get the printers:
http://google.com/groups?threadm=b23...0a% 40phx.gbl

ChristianP wrote:

Hi everyone!
I built a Form that prepares the layout of 22 sheets, but
then I would like to print them (on my PC I go on the
default printer) but i need to show the end-user the list
of printers that he has on his computer, therefore I
wanted to create a combobox with this list.

Thank you in advance!

Chris

--

Dave Peterson