Excel Quickie 20 - Stop Events from Triggering when Using Macros in Excel

This Excel VBA tutorial teaches you how to create macros that will run in a worksheet without triggering any events that may be linked with this worksheet.

For instance, you may have a macro that runs when a cell has a value input into it, but you want to be able to input a value into that cell using another macro and not have the automatic macro triggered - this is what you will learn how to do here.

This is a great little tip for macros and vba in Excel and it will prevent many future headaches, including the dreaded infinite loop, which can cause Excel to crash.

Take a moment to memorize this little tip for programming in Excel, it's worth it!

Enjoy,

[stevennye]

This is excellent, I had spent a couple of hours on an event that never worked, this solved the problem!

[wayneedmondson]

Hi.. great quickie tip to avoid endless loops when using worksheet events combined with other macro procedures that might inadvertently trigger those events. Noted and added to my VBA toolbox :)) - Thumbs up!

[daddyn]

Hello,

I have a work book with 400+ business names, and 20 to 30 products per business, I need to create a column with addresses.

Column a (business name)
Column b (product name)
Column c (product description)
Coulmn d (hopefully business address) Am I stuck with copy and paste?