set Data validation in input box to accept only date format mmm-yyyy

**Howardc1001** · 08-19-2019, 08:33 AM

I have the following code below

I would like the code amended so that only format mmm-yyyy is accepted

If for eg July-2019 is entered, then message so say "date format not valid enter date format as mmm-yyyy

Please Login or Register  to view this content.

It would be appreciated if someone could assist me

**jindon** · 08-19-2019, 08:55 AM

Please Login or Register  to view this content.

**Howardc1001** · 08-19-2019, 09:49 AM

Thanks Jindon. Code works perfectly

set Data validation in input box to accept only date format mmm-yyyy

LinkBack

Thread Tools

Rate This Thread

Display

set Data validation in input box to accept only date format mmm-yyyy

Re: set Data validation in input box to accept only date format mmm-yyyy

Re: set Data validation in input box to accept only date format mmm-yyyy

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Check Date Format Input into Excel Column with VBA code ("DD/MM/YYYY" format)

How to insure a user is prompted to input a date as format MM/DD/YYYY

Forcing date format (dd/mm/yyyy) using data validation

[SOLVED] Check Date Format Input into Excel Column with VBA code ("DD/MM/YYYY" format)

Convert Date format from Text format reading m/d/yyyy to dd/mm/yyyy

VBA Macro to capture DATA in dd/mm/yyyy even though system date format is mm/dd/yyyy

[SOLVED] Imported data contains strings dd.mm.yyyy how can I convert to date format dd/mm/yyyy inVB

Bookmarks

Bookmarks

Posting Permissions