Why not use the workbook change event, which is triggered everytime a cell
in the workbook is changed. Try putting the folliwng code behind
ThisWorkbook
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
MsgBox "The Workbook has Changed"
End Sub
"Zak" wrote in message
...
Hi
I am trying to get an alert message up on screen (a bit
like msgbox in VB) in windows, after a value is updated in
a excel spreadsheet.
I guess it will involve an API call to Windows from Excel,
in response to an event.
Can anyone help me on the issue ?
Regards
Zak
----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---