Or, for the three options the OP asked about, he could use three
CommandButtons in place of the ListBox.

--
Rick (MVP - Excel)



"Mike" wrote in message
...
You need to create a userform to do what you want. Then on your userform
put
a listbox with sheetnames and then the user could select the sheetname
from
the listbox and hit ok.

"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?