The second method is to add some VBA code to the sheet event that will stop anything but a date being entered into a range or cell. Look at the illustration below for the details. Make sure that your error message is set to Stop. While the dialogue box is open add an import message and an error message.

Use data validation in the cell range to allow only a date to be entered.Ĭhoose the Data tab and then select Data Validation/Allow/Date/Between/Enter Starting Date/Enter Finishing Date.

Here are three easy methods to remedy that Method 1. Watch this video for an overview of “ restrict cells to a date format ” Note: This is not the completed project it is a template to help with the project.

Download the free template to get you started. How not to mess up when you’re on a date and restrict cells to a date formatĭownload the template from here. So how do we restrict cells to a date format. What happens all the time is that they may not add a correct date and application fails or give incorrect data. We need to allow the user to add a date that we are going to filter or reference in our application. The first topic I’ve chosen is one that is often faced in project application development. This will enable me to reference these articles as we develop more complex projects, making the projects a little bit smaller and easier to get through. Each week I will be adding an article that shows how to solve a problem that you will face in real life applications. I’ve decided to add a new feature to Online PC.

Here are three easy methods to remedy that.

How not to mess up when you’re on a date.

Add calendar date picker to excel 2013