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

On Tue, 14 Oct 2008 04:25:01 -0700, GillianX
wrote:

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.