Displaying data entry place holders and delimiters during data entry

Davmacrat 

It is possible to create an input form in Excel that can help users enter data in a specific format.

You can use VBA (Visual Basic for Applications) to create a UserForm that displays the placeholders and delimiters for date and time entry.

The UserForm can be programmed to accept user input and automatically format it as a date and time value.

This value can then be used in calculations within the Excel workbook.

You can use the BeforeUpdate event of the TextBox to format the entered text as a date and time. For example, you can use the Format function to change the date to a standard format. Another option is to add a Date and Time Picker control to your UserForm. This control allows users to select a date and time from a calendar-like interface. You can then use the Change event of the Date and Time Picker control to validate the entered date and time and ensure that it falls within the desired range. 

Another solution to create a data entry form in Excel without using VBA is to use Excel’s built-in data entry form feature. This feature allows you to enter data in a form structure and can be accessed by adding the Form command to the Quick Access Toolbar or the Ribbon . Once you have added the Form command, you can use it to enter data into an Excel Table. The data entry form displays each field in a row in a vertical layout and allows you to navigate between records, enter new data, and edit or remove existing entries .

I hope this helps!