Print button in userform's title bar

[mani_bbc05]

Hi Friends,

I have created a tool by using few userforms in it. Now my boss is asking me to place a print button in the title bar next to the close button.

So I wanted to know that is it possible to place a print button (in the title bar) next to close button in activeX userform?
If yes, then can you please tell me how?

Thanks all

 

[Luke M]

My first response, if it was me, would be to just put a new button somewhere within body of form. Modifying the Title Bar gets to be tricky. That would be the 2 minute solution.

If you absolutely have to have it, I'd recommend starting here:
http://www.vbaexpress.com/forum/sho...ar-of-userform&p=215622&viewfull=1#post215622

Talks about adding a custom button, which you could program to do what you want. Note that this involves a LOT more coding.

 

[mani_bbc05]

Thanks Luke for your quick reply... and for the link it helped me to know something about API...