Is there any significant difference between Control_Click() and Control_Change() on a userform?
I cannot find a way to get the form to execute just the _Change() event without the _Click() event also executing.
Is there any significant difference between Control_Click() and Control_Change() on a userform?
I cannot find a way to get the form to execute just the _Change() event without the _Click() event also executing.
What is the Control you are referring to?
The change event triggers at each change in a control, so when a selection is made in a combobox the value changes & any associated code runs.
In a textbox every character typed in will fire the event, probably not a good idea to use it like this
The click event works when a control is clicked
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks