How do I clear the Excel VBA controls on my user form in one hit ?
Posted on 2013-10-13
I have a user form with a number of controls including buttons.
One of the buttons is a CLEAR button which will clear each of the text boxes of any data. It currently does this as follows:
coClientName = ""
teClientAddress1 = ""
teClientAddress2 = ""
teClientAddress3 = ""
teClientTown = ""
teClientPostcode = ""
....and so on for the whole form.
My question is : how can I do this for the whole form in one line of code, rather than clear each control individually ?