List Validation selection
 

Hi
I have a validation which makes sure that the data entered is the same as
the information currently in the List Validation. This is working fine
however, when incorrect information is entered and the error message pops-up
and the ok button is hit then the cell doesn't allow you to select from the
drop down box.

Is there a way to include into the code that if incorrect data is entered
and OK is clicked on error message that the drop down box (List Validation)
is available to select the correct information.

At the moment the only way you can then select is by selecting another cell
and then moving the mouse over the cell so you can see the drop down arrow
which shows you the list of all data available for selection.

Thanks
Noemi