Excel Performance with Worksheet Events

Add-in Express™ Support Service
That's what is more important than anything else

Excel Performance with Worksheet Events
Excel Performance with Worksheet Events 
mwynn


Guest


Hi,

I was just curious if there is any performance degradation in Excel if I declare Worksheet and Workbook level events in my Add-In. When I program in VBA, I can see performance affected by too much event trapping.

Just curious if there would be less effect on performance by trapping events in an Add-In Express COM add-in, as compared to event trapping in Excel VBA.

Let me know your thoughts.

Thanks,
Matt
Posted 14 May, 2015 07:26:21 Top
Andrei Smolin


Add-in Express team


Posts: 18793
Joined: 2006-05-11
Hello Matt,

You can check this by connecting to worksheet-level events as demonstrated in section Step 10. Handling Excel worksheet events at https://www.add-in-express.com/docs/net-first-com-addin.php.


Andrei Smolin
Add-in Express Team Leader
Posted 14 May, 2015 09:42:08 Top