Error Message if user leaves a field blank

  • Thread starter Thread starter GillianX
  • Start date Start date
G

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.
 
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
 
Back
Top