Pop-Up Message if Cell not completed

[Wizbit10]

Hi,

I need to add a pop-up message (which stops a macro running), when certain cells are not completed - in EXCEL 2003.

All the cells are validation drop-downs so I can add a message if the wrong thing is entered but not if it's not been updated at all.

The trigger for the message should be when a macro is run to warn the user that the spreadsheet is not complete.

Does anyone know how to do this?

The code in the macro is currently:
'

Please Login or Register  to view this content.

Many Thanks!

Richard

[haripopuri]

Guess you want the pop up message before this macro is executed. You can write a simple code just after your macro Sub ...() line, to check if a particular cell value is blank.

Please Login or Register  to view this content.

[rollis13]

You can also use "Or" if there are more cells to check.

Please Login or Register  to view this content.