ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Event Handler for Controls made "on the run" (https://www.excelbanter.com/excel-programming/370260-event-handler-controls-made-run.html)

Albert

Event Handler for Controls made "on the run"
 
Hi.
I often create controls "on the run" for my userforms. However, I was
wondering if it is possible to create event handlers for these controls. If
so, how do you do it?
Thank you and Best regards,
Albert

Bob Phillips

Event Handler for Controls made "on the run"
 
It is convoluted. Why don't you create them at design time, and the event
code, and just hide them until required.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Albert" wrote in message
...
Hi.
I often create controls "on the run" for my userforms. However, I was
wondering if it is possible to create event handlers for these controls.

If
so, how do you do it?
Thank you and Best regards,
Albert




Albert

Event Handler for Controls made "on the run"
 
No can do...
The thing is I need to create a textbox for a variable number of records, so
they have to be created at runtime.
Albert

"Bob Phillips" wrote:

It is convoluted. Why don't you create them at design time, and the event
code, and just hide them until required.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Albert" wrote in message
...
Hi.
I often create controls "on the run" for my userforms. However, I was
wondering if it is possible to create event handlers for these controls.

If
so, how do you do it?
Thank you and Best regards,
Albert





Scriptick

Event Handler for Controls made "on the run"
 
If you search this group for "eventclass controls" for example then you
will find a lot of interesting threads with code and explanation. You
have to create your own classmodule to create the events.



All times are GMT +1. The time now is 02:56 AM.

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