Hi

i have below code which clear all text and combo box in userform, but i want it to skip particular text box.

Private Sub Clearfrm_Click()
Dim ctl As Control
For Each ctl In Me.Controls
If TypeName(ctl) = "TextBox" Or TypeName(ctl) = "ComboBox" Then
ctl.Value = ""
End If
Next ctl
End Sub
i want to skip text box5 from above clear form .