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]

That didnt work so the text in the opposite TextBox is still there

 

[Skyybot]

Are you looking to do the opposite of original post?

Private Sub TextBox11_BeforeUpdate()
Me.TextBox8.Value = ""
End Sub

 

[ipbr21054]

As a test i used this,

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

I type a value in TextBox8 then click in TextBox11
In textBox11 i see the number 1
The text from textbox8 is removed

Does that help

 

[ipbr21054]

Are you looking to do the opposite of original post?

Private Sub TextBox11_AfterUpdate()
Me.TextBox8.Value = ""
End Sub

I have 2 Textboxes, TextBox8 & TextBox11

I type a value in TextBox8 BUT what i want to happen is when i click in TextBox11 the value that was just typed in TextBox have it removed
The vice versa the other way around so both work

 

[Skyybot]

I edited my reply. Double check post #12.

 

[ipbr21054]

I edited my reply. Double check post #12.

Compile error

 

[Skyybot]

Compile error

View attachment 119086

Check your syntax.

 

[ipbr21054]

You mean this ?

    Private Sub TextBox8_BeforeUpdate()
        Me.TextBox11.Value = ""
    End Sub
    Private Sub TextBox11_BeforeUpdate()
        Me.TextBox8.Value = ""
    End Sub

 

[Skyybot]

You mean this ?

    Private Sub TextBox8_BeforeUpdate()
        Me.TextBox11.Value = ""
    End Sub
    Private Sub TextBox11_BeforeUpdate()
        Me.TextBox8.Value = ""
    End Sub

Yes. That gives you compile error?

 

[ipbr21054]

So i dont see what you mean then as i copied what was in #12 then did the same but reversed the 8 & 11