Make cell display [THIS] and when you click it it selects and clea

A

AY

I didn't have enough room to make a clear title, but I hope it's ok. I don't
know much about what I'm about to ask about, but I think it might have
something to do with fields. Sometimes when I download a template to Word,
there are generic words like [Your Name] in gray, which, when you click it,
becomes selected in gray, and when you start typing, clears and you can type
there. The purpose of things like that are so that you know what you are
supposed to type there without making the user select manually before typing.
I was wondering if it is possible for me to make a cell which acts something
like that in Excel 2003. I want to make a cell display text which, when
clicked, select and allow immediate typing. Thanks for your help!
 
M

mrice

I would suggest that you use a macro linked to the
worksheet_selection_change event which will clear a cell when it is
selected.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$1" Then
Target.Clear
Else
If Range("$A$1") = "" Then Range("$A$1") = "[Your Name]"
End If
End Sub
 
M

mrice

I would suggest that you use a macro linked to th
worksheet_selection_change event which will clear a cell when it i
selected.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$1" Then
Target.Clear
Else
If Range("$A$1") = "" Then Range("$A$1") = "[Your Name]"
End If
End Su
 
A

AY

Thanks, mrice, at least now I know it's possible. But I didn't understand the
jargin and directions! So can you or someone else please tell me exactly what
I need to do step by step? Thanks!
 
Top