VBA 'Enter date as' message box

[Djentle]

Hey everyone,

I'm new to the forum here, so hopefully I'm not creating a duplicate thread. I did take a search, but I couldn't find what I was looking for.

I want to create a message box that is triggered if an incorrect date format is entered into a cell. The format needs to be mmm/yy. Basically, if the user goes to the cell and enters the date correctly, nothing will happen, but if the user enters something outside of mmm/yy, a message box will appear saying 'please enter date as mmm/yy' and the string will appear in the cell after they enter and click ok.

If anyone has any advice or can give me a hand that would be greaty appreciated!

 

[AlphaFrog]

Hi and welcome.

Are you familiar with the Data Validation feature in Excel?

Excel Data Validation Examples Criteria

 

[Djentle]

Hey, thanks for the quick reply.

I wasn't aware of that feature and thanks for pointing it out. I think it should do the trick. I didn't use the settings section, just the Input Message area. Now I guess doing this won't force the user to use the mmm-yy format, but it will ask them to use it which might be good enough.

The only real difference between that and what I was looking for would be a message box that only put the input into the cell if it was in mmm-yy, otherwise it would just keep asking the user. It's too bad excel didn't have an input mask feature.

Thanks!