create popup message
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
|