The boxes have Change and Clik events, call your code from those.
HTH. Best wishes Harald
"barkiny" skrev i
melding ...
i have a userform. In that userform there are some optionbuttons and
checkboxes. And i have a textbox in which i see the results according
to above mentioned buttons.
I want this textbox updated whenever there is a change in optionbuttons
or checkboxes (I dont want to press the OK button to make the
calculations)
For example if there is such a sub like "Private Sub
Userform1_Change()" , i can use it. But i could not find such a sub
Please help
Thanks in advance
--
barkiny
------------------------------------------------------------------------
barkiny's Profile:
http://www.excelforum.com/member.php...o&userid=20397
View this thread: http://www.excelforum.com/showthread...hreadid=566387