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.
|