View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel[_5_] Nigel[_5_] is offline
external usenet poster
 
Posts: 42
Default Call up a Windows Message from Excel

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 =---