Thread: [Solved] Cell properties: next cell
View Single Post
 
Old 10-28-2014, 07:19 AM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Yes, there is! You can write a macro with a particular name—WorsheetChange, or something like that; I've done it but I forget the exact name—and store it in a particular place, not an ordinary module but another place which we can show you, and as a result the macro will run every time someone changes a cell value. Then you can teach the macro to check which cell was changed (and exit if it's anything but a certain range, so that normally no one will notice it's there at all), but if the change meets certain criteria the macro will do whatever you choose, such as moving the selection to another cell of your choice.

[Later:] I forgot, I have such a macro in a worksheet I keep open almost all the time. It's called Worksheet_Change.
Reply With Quote