Hello,
For monitoring MyRange1, I am using:
I want to add two more ranges to monitor: MyRange2 and MyRange3 and get a message like:
Please Login or Register to view this content.
"MyRange2 CHANGED" or "MyRange3 CHANGED".
How do I do this?
Could you please advise?
Thanks
See if this does what you need.
This is based on named ranges with workbook scope, if your ranges have worksheet scope with the same name used on more than one sheet then you may encounter errors.Please Login or Register to view this content.
jason.b75,
This code works fine, however, what I want is to run a different code for each change.
For example:
- if I change My Range1 then get a message like "MyRange1 Changed"
- if I change My Range2 then get a message like "MyRange2 Changed"
- if I change My Range3 then get a message like "MyRange3 Changed"
Thanks
That is exactly what it does.
The code finds which range the target cell falls into then displays the name of the range, followed by the word "changed".
jason.b75,
Yes, I see, I does the job, but what I need in my situation is, to monitor only those three cells.
What happens here, is that if a cell is also part of another range like the PrintArea, than it returns the name of the PrintArea instead of the name of that particular cell.
So partially following your solution, I want to monitor a range which would contain only those three cells; thinking to have a range like RangeToMonitor which would be made up by those three cells.
Thanks
If you have overlapping named ranges then I think you will need to check each individually, I was trying to simplify the process, but in this case I don't think that it will work.
I think that this method should do what you need, you can add in more ElseIf lines if needed.Please Login or Register to view this content.
Jumping in here kind of late, but you can change more than one cell and trigger your code.
If you select more than one cell type a number into the first cell and type control + enter all the cells will change and you will get a match for your range changing if one of the cells was in your range. If you select multiple cells and select delete you have changed all of those cells and again if one of them was in your range you will get a positive with intersect.
What is done a lot of times is if you are interested in only one cell being changed you start the code with something like the following. You can also write it to deal with more than one cell being changed if you don't want to allow that to happen.
I'm not sure what you are after and this may be a non issue but I thought I would bring it up.Please Login or Register to view this content.
Last edited by skywriter; 09-19-2015 at 04:42 PM.
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks