Clear text in textbox upon clicking it

Question

I have text in a textbox, which says "NEW NAME HERE"

Is it possible with in VBA to clear this text as soon as the user clicks in that textbox?

If so could anyone please let me know how?

THANKS-

Answer 1

Assuming the TextBox is named TextBox1, the following should work

Private Sub TextBox1_GotFocus()
    TextBox1.Text = ""
End Sub

Answer 2

I know it's an old post, but I just stumbled upon it, and thought I'd add an answer. Maybe someone will find it useful some day :-)

I would check the current value before clearing the content. That way it clears the content when you first click it, but if you click it again later (to edit the name perhaps) it does nothing, allowing edits without having to start over.

Assuming the TextBox is named TextBox1 and the placeholder text is NEW NAME HERE, the following should work

Private Sub TextBox1_Enter()
    If TextBox1.Text = "NEW NAME HERE" Then
        TextBox1.Text = ""
    End If
End Sub

To restore the placeholder text if the textbox is left empty:

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
    If Trim(TextBox1.Text) = "" Then
        TextBox1.Text = "NEW NAME HERE"
    End If
End Sub

Tested in Word 2010 VBA