Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Allow selection of Validation List in a Protected Cell | Excel Discussion (Misc queries) | |||
Display part of list dependant on Validation list selection | Excel Worksheet Functions | |||
validation list - filter based on selection | Excel Worksheet Functions | |||
validation list--list depends on the selection of first list | New Users to Excel | |||
Data Validation list selection question | Excel Worksheet Functions |