You can use the "Input Message" tab in Data/Validation: you can set an
optional title (in bold) and the message.

The advantage over a comment is that it will appear if selected by
keyboard navigation too.

On Jun 5, 10:24 am, Ann wrote:
thank you!

"Mike H" wrote:
I thought you might so here's one I prepared earlier. Right click your sheet
tab, view code and paste this in. Cirrent works on a1 - A10 so change to suit

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Cells.Count 1 Then Exit Sub
If Not Intersect(Target, Range("A1:A10")) Is Nothing Then
msg = "This is to remind you of something"
response = MsgBox(msg, vbCritical)
End If
End Sub

Mike

"Ann" wrote:

don't really want a comment box, i want a popup box to show on the screen
(like an error message that pops up).

"Mike H" wrote:

Ann,

Insert a comment with
Insert|Comment
Enter your text.

As soon as they select the cell the comment is displayed. If you want
something else then post back.

Mike

"Ann" wrote:

my mind is totally not working right now. i want to create a popup message
when someone clicks on a particular cell. i know this can be done with
data, validation, but i don't want it on an error, i just want a reminder
when they click a particular cell. tia