Remove Value from TextBox if another Textbox is selected

[ipbr21054]

Hi,
Im not sure what the procedure is called but,

On my userform i Have 2 Textboxes.
TextBox8 & TextBox11

If i click in TextBox8 & type a value but then click in TextBox11 im looking to have that typed value removed.
Cant think of procedure name to use.

Something like If TextBox8 has Focus Then ???
Please advise

 

[ipbr21054]

Thought this would do what i requite but no

    Private Sub TextBox8_Click()
       If TextBox11.Value > 0 Then
          TextBox11.Value = ""
          End If
    End Sub

 

[ipbr21054]

This wouldnt also work

    Private Sub TextBox8_GotFocus()
       Me.TextBox11.Value = ""
    End Sub

Or this

    Private Sub TextBox8_GotFocus()
       Me.TextBox11.ClearContents
    End Sub

I will await a reply Thanks

 

[ipbr21054]

Anybody advise what im doing wrong please

 

[NoSparks]

In the VB editor, do you see Click or GotFocus in the TextBox8 drop down list of events ?

 

[ipbr21054]

Not back for a couple hours so will need to check then.
In my previous posts above I did use click & Got Focus but is it written then incorrectly as I typed it out as opposed to selecting it from where your asking to look.

 

[ipbr21054]

In the VB editor, do you see Click or GotFocus in the TextBox8 drop down list of events ?

No neither are there ?

 

[Skyybot]

Both are on the same UserForm?

 

[ipbr21054]

The 2 text boxes I mention are both on the same userform.

 

[Skyybot]

Private Sub TextBox8_AfterUpdate()
Me.TextBox11.Value = ""
End Sub