I placed a command button on userform of an excel workbook and named as PRINT. In that, I have written on click event as

me.printform

Now, when I click on the command button the form is printing with showing the PRINT dialogue box. Here, I need to choose the printer to be print the form but what is happening it is printing on the default printer connected without asking through the dialogue box.

Pls suggest code to get the printer dialogue box.