Add a custom command button to a worksheet to provide an easy way to launch a macro. Give the button a meaningful name before you create an event handler for it.
Assign a MouseMove event handler to a control to get extremely frequent events that don’t even require a click. Use the Shift argument of the MouseMove event to fine-tune the behavior of the event handler.
If you want a worksheet event handler to run for any worksheet in the workbook- including new worksheets-create the event handler at the workbook level.
Any event handler that begins with the word Before can be cancelled. Just add the statement Cancel=True to the body of the event handler to block what Excel would otherwise automatically do with that event.