MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Event Handlers


Posted by Bill Mason on September 03, 2000 7:05 AM


Posted by Bill Mason on September 03, 0100 7:09 AM

Hello All:

I'm struggling with the concept of event handlers. I want to compare a cell whenever it is changed with the value of an existing cell on another worksheet, and display a message box to warn if they are not the same. I think that I need to use a worksheet_selectionchange event, but the "target as range" concept confuses me. Any help would be appreciated.

Thanks in advance

Bill

Posted by Celia on September 03, 0100 5:20 PM


Bill
I think you probably need a Worksheet_Change procedure. The following article in the MS Knowledge Base might help in understanding the concept :-
http://support.microsoft.com/support/kb/articles/Q213/6/12.ASP?LN=EN-US&SD=gn&FR=0

Post again if you still need help.
Celia