Exception to If/Then statement

[JBDC]

I have created a userform with many TextBoxes and ComboBoxes. To clear them all at once after inputs are entered, I have used the following code:

Please Login or Register  to view this content.

TextBox1, however, contains the day's date and should not be cleared. Is there a way to specify that all boxes are cleared EXCEPT TextBox1?

[skywriter]

Try this.

Please Login or Register  to view this content.

[JBDC]

Thanks! I think a line fell out of your version, but after reinserting it, it worked great! Thank you!!
Final version:

Please Login or Register  to view this content.

[skywriter]

If you mean the for each part, I probably just didn't copy it from your original post. If you think about it where you moved the line you will run that line of code every time, which isn't necessary. In my version it only runs if the control type has been verified to be a text box. Make sense?

[JBDC]

Yes, it does make sense. I did your way first, actually, but got an error message saying that there was an End If without an If. That didn't make sense to me, but I saw that the one line wasn't there and I tried putting it back in, which worked.

[skywriter]

Here's another possibility. It works, I tested it.

Please Login or Register  to view this content.