Worksheet: LOG

LOG worksheet keeps the messages that created by certain code, particularly from function MsgBox.

Some technical background: Traditional VBA MsgBox is blocking function that blocks the code from running until user clicks the button on the MsgBox Window. This behavior is not desired when Excel is supposed to be running continuously when there are some minor warning or error messages occurred. LOG worksheet is very helpful in this case to trap the message from less critical MsgBox calls and let the code continue to run.

Buttons on the LOG Worksheet

The following buttons are presented on the LOG Worksheet. You can click the button to perform certain action.

Button: Clear Log

Click this button to clear messages on LOG worksheet.


You are very welcome to leave comments or suggestions for the above contents.

Hint: click "Show Comments" below, or "Discuss" at the bottom to see/join discussions on this page