Message Box For Missing Data

Hope someone can help me. I have ben given a excel file from another department at work as they had been told i know a bit about excel. Excel... Yes, Visual Basic... Nil, zilch, nada! It really might as well be written in chinese!!

What has happened is the guy who set this up has since been made redundant from the company and they now want the file to do one more thing.

Basically what they want the file to do is, when the user clicks the 'generate file' button, if E2 has no date entered then a message box pops up stopping the user from going any further until a date is entered.

Any questions please ask and i'll try to answer your questions.

There is an existing button that runs some code? If so, add this line at the beginning:

Please Login or Register  to view this content.

First make sure that cell E2 has data validation on it and that it requires the data to be an actual DATE.

Then add this line of code near the top of your macro:

Please Login or Register  to view this content.

Would you please mark the thread as Solved?

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes