Compulsory text in a cell

[wnoland]

I'd like to tell users what to input with existing text. If cell contents are deleted or it remains blank and nothing is input, default text should display i.e. Enter Client Name.

Been trying to get there with conditional formatting and I can't make text appear when starting with blank

 

[JoeMo]

I'd like to tell users what to input with existing text. If cell contents are deleted or it remains blank and nothing is input, default text should display i.e. Enter Client Name.

Been trying to get there with conditional formatting and I can't make text appear when starting with blank

Conditional formatting can't return a text string. You need a worksheet_change code to do this. What range on the sheet do you want to cover, or if just a single cell, what is the cell address?

 

[wnoland]

Conditional formatting can't return a text string. You need a worksheet_change code to do this. What range on the sheet do you want to cover, or if just a single cell, what is the cell address?

cell would be B2

 

[JoeMo]

cell would be B2

Put this in a module for the worksheet of interest. To do this:
right-click the sheet tab and choose "View Code"
copy the code below and paste into the white space in the window that opens
close the window and save the workbook. If using Excel 2007 or later version, use SaveAs and save as a macro-enabled workbook (.xlsm file extension).
Be sure to enable macros or this won't work.
When the user deletes content from B2 this will return "Enter Client Name" to B2.

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("B2")) Is Nothing Then Exit Sub
If IsEmpty(Range("B2")) Or Range("B2").Value = vbNullString Then
    Application.EnableEvents = False
    Range("B2").Value = "Enter Client Name"
    Range("B2").EntireColumn.AutoFit
    Application.EnableEvents = True
End If
End Sub

 

[wnoland]

Thanks Joe--worked like a charm!