userform, how to update the form

[Southern at Heart]

My userform has a bunch of controls on it. Many controls are affected by
others. Is there an easy way to have the whole form 'refresh' itself after
the user clicks any button, chooses any option, etc. The only way I know it
to put an 'on click' event in code for every single control that will change
some other part of the form, and have all these 'on click' events run the
initialize sub.
Is there no way to code it so that if the user click anything, any choice,
anywhere on the form, that it will update via one sub?
thanks,

 

[Shauna Kelly]

Hi Southern at Heart

It's not possible to do what you have in mind. Create a Sub that does
what you want to happen, and then have a click event for each relevant
object, and call your Sub in each click event.

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word