#1
|
||||
|
||||
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? |
#2
|
||||
|
||||
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] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro or user function to Extract row height | Catalin.B | Excel | 12 | 06-22-2011 09:21 AM |
Will Microsoft Office 2010 Offer an Upgrade Version? | benjo | Office | 4 | 06-08-2010 04:06 PM |
Word options | ehrenben | Word | 1 | 04-29-2009 02:27 PM |
autocorrect options | nancygene | Word | 0 | 01-18-2009 03:09 PM |
User seeing other user's color categories | MTFysherman | Outlook | 0 | 11-13-2008 04:36 PM |