Can a msgbox have its button names changed?

[suepowell]

Hi

I need a popup form with 3 buttons, and the simliest way to do this is to have a msgbox, as all I need to know is which one is pressed and run the correct code.

To make it really simple for the users I want the buttons to have their names set to what is going to happen, rather yes, no cancel and explain in some text what each one means.

I have a feeling this is not possible, and I'll have to do my own pop up form, but does anyone know if it can be done.

Thanks in anticipation.

Sue

 

[FoFa]

Yes, No cancel is one of the options for a MSGBOX, use help.

 

[daveUK]

Sue,

Look up 'MsgBox Constants' in VB help and it will show you the buttons available, but from the sounds of what you want, you will probably have to create your own form.

HTH