Home » Forums » Open Source Learning Center » Question and Answer

Clear all the text box together

Submitted by Seemant on 5 April, 2010 - 04:24

 I am using more then one text box in one form, i want to clear all these text boxes in one shot. currently i am doing it individually like "textbox1.value="",textbox2.value="" ...". Can any body tell me better way to do the same?

‹ how to arrange from max to min the results (from formula) Multiple date from one cell ›
»

clear text boxes

Submitted by Anonymous on 9 April, 2010 - 08:03.

For Each theControl In UserForm1.Controls
theControl.Value = ""
Next

»