Change value of cell with validation list

Hi All.

I have a cell that uses a validation list. If the user picks one of the values in the dropdown list, and I dont like it, I want to tell them they cannot choose that value, and using VBA set the value back to what it was or to something else in the list.

Thanks.

Steve
Harrisburg, PA USA

Why let them pick it in the first place?

Use the sheet's Change event to do it. I would need details to provide specific code.

Hi Ken.

I have a blank form for them to fill in. In the valdation list, The top (default) value is "Please Select". Once they select something else, no problem. But if I have these 5 validation list in column A1, B1, C1, D1, E1, I don't want them to make a selection in A1, Skip B1, and then do C1. They must start at the left and move right without skipping any for the calculations to be correct.

In that case, the SelectionChange event might be best.

Right click the sheet's tab, View > Code, and paste:

Please Login or Register  to view this content.