Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Can locating "FIND" results be made easier on the eyes? [Office 20 | Excel Discussion (Misc queries) | |||
CommandBars("Worksheet Menu Bar").Controls("Tools").Enabled = Fals | Excel Programming | |||
File Always Asks "Save Changes Y/N" even when no changes made | Excel Programming | |||
Can ActiveX controls be "disabled" and "enabled"? | Excel Programming |