Create a User Form and put whatever buttons you want on it. I put together
a very simple example. I put it at http://sample/sample.xls

On Mon, 24 May 2010 08:53:01 -0700, jday
wrote:

I would like to include a message box to my macro that prompts user to select
one of two options, or to CANCEL. I know you can create an Answer Box that
provides a Y/N/Cancel option, but I really don't want to use "YES" or "NO".
For example, I'd like the message to say "Would you like to copy your data to
SHEET1 or SHEET2?" Then have buttons labeled SHEET1 / SHEET2 /CANCEL
(instead of YES / NO / CANCEL). Can this be done?