Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
clear results when any input box changes
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
clear results when any input box changes
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to clear multiple cells of input data in Excel simultaneously | Excel Worksheet Functions | |||
VBA to SQL DB with user input and results to sheet | Excel Programming | |||
Multiple input and output results | Excel Discussion (Misc queries) | |||
how do i input customer information and results of meeting | Excel Worksheet Functions | |||
Using Input Box results in a formula | Excel Programming |