you may also try this on the Activate event of your UserForm
Private Sub UserForm_Activate()
    Dim ctl As Control
    For Each ctl In Me.Controls
        If TypeOf ctl Is TextBox Then
            ctl = ""
        ElseIf TypeOf ctl Is CheckBox Then
            ctl = 0
        End If
    Next
End Sub