Userform - Stop Command button working if a textbox is blank?

Hi There,

I'm not sure if this is possible, but what I'm trying to do is create an error message that will prevent a user selecting the command button in a userform if a text bos is empty.

I've attached a spreadsheet with a simple, example userform. What I would like to do is stop the user adding the record if the "service date" text box is empty. Idealy I would like an error message to display something like "please enter service date". Is this possible to do?

Below is the code.

Please Login or Register  to view this content.

Why are you pre-populating the TextBoxes?

Please Login or Register  to view this content.