Userform textboxes undo vba code

Hi,

Assuming you aren't using the Tag property for anything at the moment, you could store the old values there like this

Private Sub cmdReset_Click()
    For Each ctl In Controls
        If TypeName(ctl) = "TextBox" Then
           ctl.Tag = ctl.Text
           ctl.Text = vbNullString
        End If
    Next

Then if you need to undo that, simply add a button to put the tag back

    For Each ctl In Controls
        If TypeName(ctl) = "TextBox" Then
           ctl.Text = ctl.Tag
        End If
    Next