clear results when any input box changes

J

Jacob

I have a userform with quite a few input textboxes and output (results)
textboxes. I want the results textboxes to clear when any input
textbox is changed. is there an easier way to do this than to write a
sub that clears the results textboxes, and write a change event for
every input textbox that calls the clear sub? I could do that, but it
seems there would be easier way. thanks
 
G

Guest

I have not tried it but it seems that if your text boxes are named, you could
put the ones you want to clear in an array and clear them all at once.
 
J

Jacob

it's not so much the clearing of the textboxes that i am concerned
with. I am more concerned with having a separate change event for each
trigger textbox. does that make sense?
 

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