The question is this...
5 Cells have "input message" data validation on them.
I have one "yes" and one "no" checkbox for each of them.
When I click the "no" checkbox, it activates the next CELL down. I have proved to myself that this is, indeed the active cell.
How do I force the data validation, to display the input message, when the cell becomes active? Cause right now, it seems that the input message only kicks in when you *leave* the cell.
If I tab to the cell, hit enter, or click on the cell, the input message validation appears right away, but not if I say "Range("A27"
.activate"
Is this a problem because I'm not actually entering or changing the information in these cells at all and the Data validation input message is waiting for me to change something?
5 Cells have "input message" data validation on them.
I have one "yes" and one "no" checkbox for each of them.
When I click the "no" checkbox, it activates the next CELL down. I have proved to myself that this is, indeed the active cell.
How do I force the data validation, to display the input message, when the cell becomes active? Cause right now, it seems that the input message only kicks in when you *leave* the cell.
If I tab to the cell, hit enter, or click on the cell, the input message validation appears right away, but not if I say "Range("A27"
.activate"Is this a problem because I'm not actually entering or changing the information in these cells at all and the Data validation input message is waiting for me to change something?
