Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call up a Windows Message from Excel
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 =--- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i want all windows in one excel frame (windows in taskbar) | Excel Discussion (Misc queries) | |||
Windows application error message | Excel Discussion (Misc queries) | |||
Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
windows help message board? | Excel Discussion (Misc queries) | |||
Windows cannot find file message | Excel Discussion (Misc queries) |