How to create multiple text placeholder that disappears when user click on them

[matteoB]

Hi everyone!

I am wondering how to create text placeholders in cells that disappears when users click on them in order to fill with information, like some online form that you have to fill to register some service or account.

For example, I have a sheet with a form where I need that users insert some info as "City", "Address", "Day" and "Time". Every of these cells have the relative placeholder "City", "Address", "Day" and "Time" wrote in color grey. When users double click on them, the placeholders disappear and users can enter their text (i.e. I want the text in the exact cell to be used).

Thank you in advance,
Matteo

 

[Logit]

https://excelribbon.tips.net/T000614_Showing_Text_when_a_Cell_is_Empty.html

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$B$4" Then
        If Target = "" Then
            ' Cell is empty; mark it and make gray
            Target = "(Customer Name)"
            With Selection.Font
                .ThemeColor = xlThemeColorDark1
                .TintAndShade = -0.249977111117893
            End With
        Else
            ' Cell contains something; remove gray
            With Selection.Font
                .ColorIndex = xlAutomatic
                .TintAndShade = 0
            End With
        End If
    End If
End Sub

Here is another method ... if all "suggested text" is located in the same column :

Instructional text in cells in Excel | Western Sydney University

As you can see from the instructions ... this method uses a 'helper column' that is partially hidden.