Data Validation problem

[ILuvExcel]

Hi There,

I am designing a form in Excel (2003) on which users need to select a value from a dropdown list (complicated options & spelling, so we do not want users to type their answers). I have activated the STOP Error Message for Data Validation but ran into the following problem:

When a user enters invalid data, the error message is displayed but when the RETRY button is clicked Excel does not allow the user to select from the drop down list (which to me would be the logical thing to do). If the user clicks CANCEL the invalid entry is removed and they can select from the drop down list again.

Any ideas why this is happening? Am I missing something or is this just the way Excel handles a situation like this?

Please help!

 

[Andrew Poulsom]

Welcome to the Board.

That's just how it is, I'm afraid. Retry selects the text for editing.

 

[ILuvExcel]

Thanks Andrew.

I guess there is no way to rename the buttons?

 

[pedro-egoli]

Perhaps if you word the Error message that incorrect input has been used and to click "Cancel" and retry , that would assist all users.

Pedro