How do I add typing instructions to an Excel cell?

W

wjs2ps

Is there a way to add instructions to a cell and have it appear "in the
background" when the cell is selected, then disappear when text is typed?
For example, "Type last name, press TAB".
 
J

Jacob Skaria

For auto hide and unhide. Right click on the sheet tab>View Code> and paste
the below code. Change the range accordingly. The below works in A1:J30 range.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Application.Intersect(Target, Range("A1:J30")) Is Nothing Then
Application.DisplayCommentIndicator = xlCommentIndicatorOnly
If Not Target.Comment Is Nothing Then
Target.Comment.Visible = True
End If
End If
End Sub

PS: Set the Security level to low/medium in (Tools|Macro|Security).

If this post helps click Yes
 
J

Jim Thomlinson

Data validation will do the trick.
Data -> Validation -> Input Message -> Add your Text and you are done...
 
Top