MsgBox to verify change of UserForm Textbox value?

[9iron]

When changing the value of TextBox3, I need to confirm the change with a message box with buttons (I think?)
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
“Do you want to change this value?”<o></o>
<o></o>
“Yes” allows the change and tabs to the next TextBox<o></o>
“No” prevents the change and tabs to the next TextBox.

Can Y'all help me do this?<o></o>

 

[VoG]

Try like this

If MsgBox("Do you want to change this value?", vbQuestion + vbYesNo) = vbYes Then
    '
    'code to change value
    '
End If
TextBox4.SetFocus

 

[9iron]

Thanks for the "towards" but,
I'm learning this stuff from scratch.

I don't know the code to change or keep the value in textbox3.

 

[VoG]

What do you want to change TextBox3 to?

 

[mikerickson]

You could use code like this:

Private Sub TextBox3_Enter()
    With TextBox3
        .Tag = .Text
    End With
End Sub

Private Sub TextBox3_AfterUpdate()
    With TextBox3
        If .Text <> .Tag Then
            If MsgBox("Verify change from " & .Tag & " to " & .Text, vbOKCancel) = vbCancel Then
                .Text = .Tag
            End If
        End If
    End With
End Sub

 

[9iron]

Yippie!!!

After doing some study and messin around I finally figured out how to make it work.

Thanks for the code mikerickson!