Creating custom event listener

[bradyboyy88]

Hi,

I have used tons of event methods built into excel which include window resizing, cell changing, etc and their usefulness is amazing. I was hoping I could create a custom event listener though. In particular, I create an ADO connection and manually check if Connection.Open=adStateOpen here and there . However, if there is a way to create a custom event that is triggered when this status changes then that would be great.

Any ideas?

 

[MrTeeny]

Could you use a worksheet_change event to keep an eye out for that change?

 

[bradyboyy88]

I actually never use worksheets, I am working purely out of a userform. Either way though, I need to know if the connection changes. Any other ideas?