View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Reitanos Reitanos is offline
external usenet poster
 
Posts: 123
Default 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