Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
create popup message
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
create popup message
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
create popup message
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
create popup message
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
create popup message
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
create popup message
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. "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a popup notification in excel ? | Excel Worksheet Functions | |||
excel links popup message - very annoying | Excel Discussion (Misc queries) | |||
Create a Popup box | Excel Discussion (Misc queries) | |||
Message popup | Excel Discussion (Misc queries) | |||
popup message if certain criteria met in formula result | Excel Worksheet Functions |