Well my modification didn't quite work. The way it's written, if the target cell is in column 1, then the user would not get a message box calling them a baboon. However, if the user selects a cell in column 2, 4, or 7, the user (incorrectly) gets the baboon message. In other words, the case statement only looks at the first value ("1") as the only way to avoid getting the baboon message. Anybody know why?
In the meantime, I altered the code again and now it does what I want, but I still wonder why the code in my other post doesn't work.
Bookmarks