Expiry mm/yy and validation

[Maki]

I need to create a form where one field is expiry month & year (no date) and
set a data validation to ensure that this is current.

I've learnt in other threads that you have to enter date, even if it's a
hypothetical one, and have it not displayed.

This'll work if I'm doing the data entry but it'll have to be made for the
use of other people as well so I'd rather make it simple.

How can I have four digits entered (without "/" or hyphen) to be recognised
as mm/yy, displayed as "mm/yy" (or "mm-yy") and have the record validated to
ensure that it is future month/year?

 

[Bob Phillips]

It's easy enough but a bit more background will help.

When you say a for, do you mean a userform, or a pseudo-form within a
worksheet? If the former, is the date to be entered by the user in a
textbox?

 

[Maki]

Thank you, Bob,

It's really the latter, just a spreadsheet and no macro or VBA scripting
involved.

Would it be more complicated or less?

 

[Bob Phillips]

It actually makes it simpler, but it needs VBA. Is that okay for you?

 

[Maki]

I haven't done VBA with Excel 2007 but I can give it a try...