Im looking for code that will monitor the E column and whenever the user selects Return from the drop down list it checks to see if there is data in the corresponding I or J cell (on the same row). If so a message comes up letting them know this action will erase data in the 'Item Exchange' and Exchange Unit' cells (I and J). If the user clicks ok it erases those cells, if they cancel the E column goes back to whatever value it started with.
Thanks,
James
Hi, James,
usually you could use the Worksheet_Change-event for that but I think you already have used that event for monitoring other cells so you would need to integrate the code there as well.
On itīs own the code may look like (please notice that there may only be one event of each name behind each single sheet):
Your exisiting procedure must be rewritten in order to accept this case as well.
Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks