create popup message

  • Thread starter Thread starter Ann
  • Start date Start date
A

Ann

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
 
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
 
don't really want a comment box, i want a popup box to show on the screen
(like an error message that pops up).
 
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
 
thank you!

Mike H said:
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
Click to expand...
 
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.
 
Hi Mike,

Sorry to interfere. The thing you did is cool! Can you modify it that
includes date?
Let say the message " You have Termination Today : Nov.13, 2008 "

Basically, I have excel sheet and has column of date like this - 20081113
and so on..
the thing is in our computer its 2008-11-13. Instead of changing each date.
Is there a way to select all the dates and convert it to 2008-11-13 format?

thanks.
 
Back
Top