Create dropdown box in Excel VBA to select printer

[jigejo]

I am trying to setup a spreadsheet in a certain print format. Some of the available printers do not contain the necesary format and not all systems contain the same printers. I need to create a dropdown box that contains the available printers from their systems in order that they can select a printer with the available format. The 'dialogprint' does not work because when the OK button is pressed the sheet will print. I only want to set the spreadsheet up with the proper format.