Re: $$Excel-Macros$$ to get printing dialogue box on printing

thank you noorain for providing solution. I will try and let you know the result. On Tue, Sep 6, 2011 at 9:41 PM, NOORAIN ANSARI wrote: > Dear Bheema, > > Try it... > > Private Sub CommandButton1_Click() > Application.Dialogs(xlDialogPrint).Show > End Sub > > Thanks & regards, > Noorain Ansari >

Re: $$Excel-Macros$$ to get printing dialogue box on printing

Dear Bheema, Try it... Private Sub CommandButton1_Click() Application.Dialogs(xlDialogPrint).Show End Sub Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On

$$Excel-Macros$$ to get printing dialogue box on printing

I made a userform with a command button called PRINT and wrote the following: me.printform but it will directly printing the form without showing the Print dialogue box. how to get that dialogue box on command.click event. --