Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pop up message
Is there a way that Excel can remind me to do someting if
data in a cell is changed? Something like a reminder or a pop up? I do not want to insert a comment. |
#2
|
|||
|
|||
You could try using the Worksheet change event:
Private Sub Worksheet_Change(ByVal Target As Range) <<Sort Code End Sub Hope this helps Sunil Jayakumar "esei" wrote in message ... Is there a way that Excel can remind me to do someting if data in a cell is changed? Something like a reminder or a pop up? I do not want to insert a comment. www.ayyoo.com/credit-cards.html |
#3
|
|||
|
|||
Does the cell change by you typing something?
If yes: Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count 1 Then Exit Sub If Intersect(Target, Me.Range("a1")) Is Nothing Then Exit Sub MsgBox Target.Address(0, 0) & " Has changed!" End Sub rightclick on the worksheet tab that should have this behavior. Select view code. Paste that in. (Change A1 to the cell you want.) Back to excel and test it out. esei wrote: Is there a way that Excel can remind me to do someting if data in a cell is changed? Something like a reminder or a pop up? I do not want to insert a comment. -- Dave Peterson |
#4
|
|||
|
|||
Have you tried Data Validation in the Data menu?
"esei" wrote in message ... Is there a way that Excel can remind me to do someting if data in a cell is changed? Something like a reminder or a pop up? I do not want to insert a comment. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculations And Order In Macros | Excel Discussion (Misc queries) | |||
when opening excel I receive a message that says file can't be fo. | Excel Discussion (Misc queries) | |||
changing the message in an error message | Excel Worksheet Functions | |||
Error Message appearing when saving a file | Excel Discussion (Misc queries) | |||
#num! error message | Excel Worksheet Functions |