I have one stupid niggling little issue with my Excel sheet.
I have several sets of two checkboxes - one "yes" and one "no".
If the "yes" is checked it goes to a cell for you to enter more information using the .activate method.
If the "No" is checked, it goes to the next set of checkboxes.
I have Data validation on the cell that activates when you click on "no" that brings up an "information" input message. The problem is that when you click on the "no" the input message that shows up is the input message from the cell that *prviously* had the focus, not the one that gets the gocus when you click no.
But if you click "no" then *un*click "no" then click "no" again, the right cell has the focus and the right input message is seen.
I'm assuming that there's a timing issue involving the built in Data validation that I'm using for the input message and the VB stuff I'm using to "activate" the next cell, but I can't figure it out.
I have several sets of two checkboxes - one "yes" and one "no".
If the "yes" is checked it goes to a cell for you to enter more information using the .activate method.
If the "No" is checked, it goes to the next set of checkboxes.
I have Data validation on the cell that activates when you click on "no" that brings up an "information" input message. The problem is that when you click on the "no" the input message that shows up is the input message from the cell that *prviously* had the focus, not the one that gets the gocus when you click no.
But if you click "no" then *un*click "no" then click "no" again, the right cell has the focus and the right input message is seen.
I'm assuming that there's a timing issue involving the built in Data validation that I'm using for the input message and the VB stuff I'm using to "activate" the next cell, but I can't figure it out.