Don't bother. Use the builtin functionality

Application.Dialogs(xlDialogPrint).Show


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"FCC" wrote in message
...

Hello,

Does anyone know the code I can use to grab a list of printers my
computer?
I would make this list into a combo to allow my users to select a
printer.

Thanks


--
FCC
------------------------------------------------------------------------
FCC's Profile:
http://www.excelforum.com/member.php...o&userid=35888
View this thread: http://www.excelforum.com/showthread...hreadid=558057