Can events work with run-time-created Forms-controls?

[PSC]

Hi

I have a specific question about getting events to work with run-time created controls of VBA forms version 2.01

I've made a VBA form that has 2 static command buttons (OK and Cancel). The init-sub of the form creates x option buttons at run-time. The content of the option buttons are fecthed from an Excel Range.

What I now do is to scan through the Controls("name of the control") in a loop to figure out which option button is currently active when the user click on the OK-button.

It all works well, but I want to enable *_DblClick() event for all the option buttons so it is possible to make a choice by double-clicking on any of the option button.

If I create event-subs myself identical to what they would get at creating them at design, they will not trigger.

Does anyone know how the fetch double-click event on controls created by code at run-time? If you do, please, let me know.

 

[PSC]

Thank you Tom

The code works like a charm.

The only modification required to get it to work in VBA 5 was to define the Subs as Public instead of Friend.

I was wondering before why I could define Subs as Public in a code of a form but was unable to call them from a module. Now, I know.

It seems like I haven't gone my last "class" after all. :wink:
Now I know that "classes" are good for something.

Thanks again, and if you have any succestion of a good VBA book that you've read yourself, please, let me know.

 

[Legacy 98055]

See my previous post. It think you may have missed it. I mentioned a book there.

 

[PSC]

You're right as usual Tom, Sorry.