Hi
i have below code which clear all text and combo box in userform, but i want it to skip particular text box.
i want to skip text box5 from above clear form .![]()
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
Bookmarks