Excel Video 433 takes Message Boxes a step further by customizing the message buttons. The trick is that instead of using a default like vbOKCancel or vbInformation, try using a number instead. Here’s the URL for the page I reference in the video:
http://msdn.microsoft.com/en-us/library/aa445082(v=vs.60).aspx
By adding the numbers of the various options together, you can get the buttons you want, the message style you want, and you can even choose the default button. The final step is to actually do something based on the button the user choose. In the next Excel Video I’ll show you how to capture which button the user choose. I look forward to seeing you then.
