Custom Captions For MsgBox Buttons 1

[jaeyoo]

How do I create custom captions for MSGbox buttons?

I want to add three of my own buttons but MSGbox doesn't let you change the captions on the buttons.

 

[PHV]

Why not create a small UserForm with the controls you want ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jaeyoo]

How do I do that? sorry i'm pretty new at this vba stuff

 

[xlbo]

when in the VB Editor, go Insert>Userform

You should then be able to place buttons and labels on it.

Post back if you need any help with the code to show / action it etc

 

[jaeyoo]

Thank you!!