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

 

[Skyybot]

Try this. With full arguments.

Private Sub TextBox8_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
Me.TextBox11.Value = ""
End Sub

 

[ipbr21054]

Dont know what you mean by full arguments,i copied it like above but text still in textbox

 

[ipbr21054]

Not sure i understand that last code.
Look at this,

When the user clicks in the textbox shown by arrow it should then remove the XXXXX above

 

[Skyybot]

Yeah. I don't think that I'm grasping what you are trying to accomplish. I will submit this last attempt. If you type a value in TextBox8 and then select TextBox11 the text in TextBox8 will disappear.

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

 

[NoSparks]

No neither are there ?

That's because neither are events associated with text boxes.
Try using Enter for tab, enter key or arrow key taking you to the other textbox
or MouseDown if you only want clicking into the other textbox

 

[ipbr21054]

Post #24 did it

Thanks very much