Last week a client mentioned that he uses lots of message boxes in his Excel code, and finds that users just click OK when a message appears. Most of the messages are informational, and users have read them before, so a quick click is fine.
However, some of those messages are critical, and only appear when an important decision has to be made. Because the users are so accustomed to seeing messages, they just click OK, without reading. That could cause problems!
I suggested that he add an icon to the critical messages, so they stand out from the rest.
Here’s the current code for this message.
Type a plus sign after vbOKCancel and select vbCritical from the dropdown list.
Now when the macro runs, the critical icon appears in the message, and the user is more likely to read it.