Error Message if user leaves a field blank

[GillianX]

Hi,

I have a drop down list based on a question but if a user skips the question
and doesn't select from the drop down list and doesn't click in the cell, how
can I create an error message so that they cannot leave this field blank?

Many thanks in advance.

 

[Gord Dibben]

If they don't click in the cell I don't see a way to pop up a message
without some event code.

Either selection_change code in the worksheet or..............

You could place some before_save or before_close event code in Thisworkbook
module that will pop up a message and cancel the save or close until they
fill in the cell.


Gord Dibben MS Excel MVP