Data Validation List That Cannot Be Left Blank

Hi Maniacb

I'm not sure I follow you?

I currently have a data validation list set to point at a named ranged called 'Frequency' on another sheet, and the option checked to show an error message if the user tries to enter anything that's not on the list

Picture4.png

But how do I stop the user leaving the cell blank?

All the best
V