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


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

I think you probably need a Worksheet_Change procedure. The following article in the MS Knowledge Base might help in understanding the concept :-

Post again if you still need help.