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.

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.

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.