I've used MsgBox many times when my macro just needs the answer to a yes/no question. I need to write a little macro that will offer the user 3-4 options, such as Save, Reset, Clear, Cancel.



It doesn't look like MsgBox support option for custom buttons. What's the best function to use to put up a prompt box with a set of custom buttons?

Hi Jennifer,

Try an Inputbox. For an idea of what can be done, see post #8 here: https://www.msofficeforums.com/excel...-changing.html

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]