Clearing values of Different control type inside a frame with vba

[mahhdy]

Hi,
I have a user form which includes two frames one is header and the second is "body". Each has text box and combo box controls, I want to clear all the content of body controls, no matter of the control types. Also, I need to know if I add for instance radio button How I should change the code to that control type be cleared too.
Tnx.

 

[Domenic]

Let's assume that your second or "body" frame is named Frame2, the following code will iterate through each control (textbox, combobox, and option button) within the frame and clear them...

Private Sub CommandButton2_Click()
    Dim oCtrl As Control
    For Each oCtrl In Me.Frame2.Controls
        Select Case TypeName(oCtrl)
            Case "TextBox", "ComboBox"
                oCtrl.Value = ""
            Case "OptionButton"
                oCtrl.Value = False
        End Select
    Next oCtrl
End Sub

Change the name of the frame, accordingly.

Hope this helps!