How to make pale text inside the TextBox before selecting the TextBox

[mmn1000]

Hello

How can I make watermark textbox on my textbox?

For example, have you seen that in some TextBoxes, there is a faint writing, when you select it, the writing goes "Delete" and you can type.

I want to see if it is possible to do this in VBA Excel

 

[Sparcot]

Hello. Add to userform code:

Private Sub TextBox1_Enter()
    If TextBox1.Value = "Delete" Then
        TextBox1.Value = ""
        TextBox1.ForeColor = &H80000008
    End If
End Sub

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
    If TextBox1.Value = "" Then
        TextBox1.Value = "Delete"
        TextBox1.ForeColor = &H8000000C
    End If
End Sub

Private Sub UserForm_Activate()
    TextBox1.Value = "Delete"
    TextBox1.ForeColor = &H8000000C
    TextBox2.SetFocus '<== if you have a second textbox - use this line, if not - set focus to something else (ComboBox / CommandButton etc.)
    TextBox1.SetFocus
End Sub

 

[mmn1000]

Hello. Add to userform code:

Private Sub TextBox1_Enter()
    If TextBox1.Value = "Delete" Then
        TextBox1.Value = ""
        TextBox1.ForeColor = &H80000008
    End If
End Sub

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
    If TextBox1.Value = "" Then
        TextBox1.Value = "Delete"
        TextBox1.ForeColor = &H8000000C
    End If
End Sub

Private Sub UserForm_Activate()
    TextBox1.Value = "Delete"
    TextBox1.ForeColor = &H8000000C
    TextBox2.SetFocus '<== if you have a second textbox - use this line, if not - set focus to something else (ComboBox / CommandButton etc.)
    TextBox1.SetFocus
End Sub

Thank you for your beautiful code