Events in a Userform

T

Trefor

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.
 
J

Jim Rech

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
|
| 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
 
T

Trefor

Jim, many thanks and sorry for the delay in getting back to you I have been
working on another project.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top