Hi everyone
I am using Microsoft Office (2003) and i've created a userform that allows the user to input values into text boxes which are later populated onto a spreadsheet.
My problem is that i am struggling to clear all the textboxes afterwards (there are many of them). I've tried this code:
The command under the line with the hashes does not work.
Any help would be greatly appreciated.
Thank you
Steve
I am using Microsoft Office (2003) and i've created a userform that allows the user to input values into text boxes which are later populated onto a spreadsheet.
My problem is that i am struggling to clear all the textboxes afterwards (there are many of them). I've tried this code:
Code:
Dim cCont As Control
For Each cCont In Me.Controls
If TypeName(cCont) = "TextBox" Then
'#####
cCont.value = "" (THIS DOES NOT WORK)
End If
Next cCont
The command under the line with the hashes does not work.
Any help would be greatly appreciated.
Thank you
Steve