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