Say we want cell B9 to display "Name" and we want that text to vanish if the
user clicks on B9.

First Insert a hyperlink in B9 to a place in this document, namely B9, and
make the display text "Name". Do not user the =HYPERLINK() function.

So if the user clicks on B9, the cursor jumps to B9 (not very impressive,
huh?)

Then insert the following tiny event macro in the worksheet code area:

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Target.Range.Clear
End Sub

Now:

1. the user see the text "Name" in B9
2. the user click on B9
3. the hyperlink activates
4. the macro runs and clears B9
5. the user types data into B9
--
Gary''s Student - gsnu200847


"Scafidel" wrote:

I have an Excel form type sheet that employees complete which fills other
sheets for printing. How could I have cells with instructive text that would
disappear when clicked on? Like what is used on HTML, i.e., a cell might
contain "Name," another "State," another "Zip," etc.
Thanks
--
Scafidel
Lafayette, Louisiana