ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Event class doesn't fire in embedded VBA (https://www.excelbanter.com/excel-programming/311712-event-class-doesnt-fire-embedded-vba.html)

Tornados[_5_]

Event class doesn't fire in embedded VBA
 

Hello all,

I'm using an activeX class in VBA

A certain sub is being dealt with and normally this triggers an even
(like workbook_open etc. but then for a total dfiferent class
specifically for this class...

However when i embed this function (including event that should b
triggered) into a broader sub it appears the event isn't triggere
anymore and it just moves along..

Again when i just execute the sub the event gets fired perfectl
alright.

Anyone an idea on how to move to this event anyway?

Thanks. Iv

--
Tornado
-----------------------------------------------------------------------
Tornados's Profile: http://www.excelforum.com/member.php...nfo&userid=417
View this thread: http://www.excelforum.com/showthread.php?threadid=26423



All times are GMT +1. The time now is 03:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com