change yes/no buttons
 

I have a macro that produces a message box and I have used vbYesNo so the
user can answer a question. However instead of a yes or no answer I want the
user to answer with 'left' or 'right'.

Is it possible to change the text of these buttons?

Thanks in advance.

change yes/no buttons
 

No, you'll have to go the long way round and create a UserForm with your own
buttons.

"fullers" wrote:

I have a macro that produces a message box and I have used vbYesNo so the
user can answer a question. However instead of a yes or no answer I want the
user to answer with 'left' or 'right'.

Is it possible to change the text of these buttons?

Thanks in advance.

change yes/no buttons
 

Mainly for this purpose (changing the button captions) I have made a custom
messagebox. This works with a VB6 dll file. Besides giving you the option to
set the button captions it has a lot of other useful features and I use this
now in
any non-trivial Excel application.
If you are interested I can mail the file.

RBS

"fullers" wrote in message
...
I have a macro that produces a message box and I have used vbYesNo so the
user can answer a question. However instead of a yes or no answer I want
the
user to answer with 'left' or 'right'.

Is it possible to change the text of these buttons?

Thanks in advance.