Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Events in a Userform
I have created a userform with tabs, combo boxes, text boxes, etc. I am guessing from my research here that by using an "event" I can check to see if the user has modified the form? From this event I would like to update information on the form. I am new to userforms and have never used events, could someone help me out here with some code? (I know I could add a call to every control on the form, but I would really like a catch all reduce the effort and chances that I might miss one). Any help would be very much appreciated. -- Trefor |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Events in a Userform
Double-click any of the userform controls to be taken to the userform module
and the default event handler for said control. In the right dropdown at the top of the module will be all the events that that control handles. Pick the ones you want to write code for. -- Jim "Trefor" wrote in message ... | | I have created a userform with tabs, combo boxes, text boxes, etc. I am | guessing from my research here that by using an "event" I can check to see if | the user has modified the form? From this event I would like to update | information on the form. I am new to userforms and have never used events, | could someone help me out here with some code? (I know I could add a call to | every control on the form, but I would really like a catch all reduce the | effort and chances that I might miss one). | | Any help would be very much appreciated. | | -- | Trefor |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Events in a Userform
Jim, many thanks and sorry for the delay in getting back to you I have been
working on another project. -- Trefor "Jim Rech" wrote: Double-click any of the userform controls to be taken to the userform module and the default event handler for said control. In the right dropdown at the top of the module will be all the events that that control handles. Pick the ones you want to write code for. -- Jim "Trefor" wrote in message ... | | I have created a userform with tabs, combo boxes, text boxes, etc. I am | guessing from my research here that by using an "event" I can check to see if | the user has modified the form? From this event I would like to update | information on the form. I am new to userforms and have never used events, | could someone help me out here with some code? (I know I could add a call to | every control on the form, but I would really like a catch all reduce the | effort and chances that I might miss one). | | Any help would be very much appreciated. | | -- | Trefor |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UserForm ListBox Events | Excel Programming | |||
Multipage Userform Events | Excel Programming | |||
Events for controls created on the fly on a userform | Excel Programming | |||
UserForm events | Excel Programming | |||
UserForm Events | Excel Programming |