Excel data validation

[Leslie67]

I have data validation set up in excel to provide input messages when a cell is active ("Click Yes or No&quot.

The "Yes" and "No" are checkboxes.

When "No" is clicked the cell in the next row becomes active by using "Range("a26&quot.activate"

The problem is that when "A26" becomes active, the corresponding input message isn't the one for "A26", it's for the cell that *was* active.

Any suggestions?

 

[Bowers74]

Have you tried Range("A26&quot.Select?

I'm not sure if it helps, let me know and I will look into it further.



If you can't be "The Best", be the best at what you can!!!

Never say Never!!!
Nothing is impossible!!!

 

[Leslie67]

Yes, I tried .select and it does the same thing.

The other really funky thing about this is that if you click the "no" checkbox, then *un*click the "no", then click the "no" AGAIN, then the right cell has the focus and the right message pops up.

I'm sure it has something to do with the focus and the order that things are happening, but I can't figure it.

 

[Bowers74]

Where do you have the Range("A26&quot.activate line (i.e. in which module)?



If you can't be "The Best", be the best at what you can!!!

Never say Never!!!
Nothing is impossible!!!

 

[Leslie67]

I have it on the "click" event for the chkbox:

Private Sub chkmovephoneno_Click()
If chkmovephoneno = True Then
Range("A26&quot.Activate
End If

End Sub

 

[Bowers74]

Try using both .Select and .activate:

Private Sub chkmovephoneno_Click()
If chkmovephoneno = True Then
    Range("A26").Select
    Range("A26").Activate
End If

End Sub

or:

Private Sub chkmovephoneno_Click()
If chkmovephoneno = True Then
    Range("A26").Activate
    Range("A26").Select
End If

End Sub

I'm not sure if the first one won't cause the Input message to be called, so you might want to try the second one first.

Hope this helps!



If you can't be "The Best", be the best at what you can!!!

Never say Never!!!
Nothing is impossible!!!

 

[Leslie67]

ok.... I tried that and I've still got the same issue.

I'm wondering if the focus is never acually getting to the new cell because when I step through the code it just keeps going around and around in the "click" event for the "no" button...

 

[Leslie67]

actually, I have proved that the cell does, indeed, become the active one using this message. Now it's a data validation question, I htink..

Thanks for you help.