Same answer as you got this morning when you posted same question.

Maybe you didn't see my post?

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 or sheet_deactivate 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(s).

Provide some cell references that would have to be filled.

Note: the on-line forms you mention do not pop up the message until after
you hit the "Submit" button or whatever triggers the error message.

That's what the event code does.


Gord Dibben MS Excel MVP

On Tue, 14 Oct 2008 13:36:01 -0700, GillianX
wrote:

Hi,

I'm struggling still with a problem I have. It seems simple enough but as
I'm fairly new to working with spreadsheets, I can't figure it out.

You know when you complete say, an online order form and if you haven't
completed a field you get asked to fill it in? Well, I have to create
something similar. My data is to be inputted by a user, basic stuff like Your
Name, Your Company that type of thing. For a quote to be calculate though,
all fields have to have either text or numbers or an option selected from a
drop down. What I would like to happen is that a "Please ensure all fields
are completed" box appears when a field or fields are left blank. I don't
want the box to appear when the worksheet is opened, only after one or a
number of fields are not completed.

I hope this makes sense and I hope someone can help me out.

Thanks