View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default clear results when any input box changes

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