Visual Basic Form

[Carrie_Loos via OfficeKB.com]

Can anyone tell me how to clear a form? When I first pull my form up, which
has radio buttons with code, the buttons are clear but after I make a choice
and pull it up again button is still indicated. I have to close the form and
re-open it once again to clear. What am I not doing correctly?

Thx

 

[Dave Peterson]

Do you hide the userform and then show it?

If yes, try unloading and then loading it.

 

[Alpineman2]

Try this: should work for both textbox & optionbutton

Private Sub CommandButton1_Click()
' Clear the form
Dim ctrl As Control
For Each ctrl In Me.Controls
If TypeOf ctrl Is MSForms.TextBox Then
ctrl.Value = ""
ElseIf TypeOf ctrl Is MSForms.OptionButton Then
ctrl.Value = False
End If
Next ctrl
End Sub

 

[Carrie_Loos via OfficeKB.com]

This works well - Thanks

Try this: should work for both textbox & optionbutton

Private Sub CommandButton1_Click()
' Clear the form
Dim ctrl As Control
For Each ctrl In Me.Controls
If TypeOf ctrl Is MSForms.TextBox Then
ctrl.Value = ""
ElseIf TypeOf ctrl Is MSForms.OptionButton Then
ctrl.Value = False
End If
Next ctrl
End Sub