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

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.

"Jacob" wrote:

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

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?


JLGWhiz wrote:
> 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.
>
> "Jacob" wrote:
>
> > 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
> >
> >