Best way to offer macro user options?
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?
|