Need help with enabling events

Hi,

I was provided code by LJMetzger which I think originated from Andy Pope.

I modified it to handle more than just text boxes. There is a class module called ClassEvents which is supposed to handle Change, Dbl Click, etc. f

In my module I have (and this works)!:

Please Login or Register  to view this content.

and (this following bit that is giving me trouble):

Please Login or Register  to view this content.

but my Events are not working. Here is the contents of the ClassEvents:

Please Login or Register  to view this content.

I added the call to build the control (just one), and enable the control for testing purposes:

Please Login or Register  to view this content.

to ThisWorksheet. I tried TextBox and ComboBox; neither works, yet in the sample LJMetzger sent; it does. I get no errors. Anyone have any idea what I'm doing wrong?

You're right, I removed the call, and then called EnableEvents manually by calling the macro and it worked.

I replaced the EnableEvents call I had with:

go = ActiveSheet.OnTime(Now + TimeValue("00:00:03"), "Module1.EnableEvents")

and I get an "Object doesn't support this property or method" error. What am I doing wrong?

I'm trying to create them then add events to them to enable the interaction I need. Almost there. Thanks

I had that. I get an "Expected Function or Variable" compile error. BTW, my combox boxes are not working (no events).