Expiry mm/yy and validation
 

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?

--
Maki @ Canberra.AU

Expiry mm/yy and validation
 

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?

--
__________________________________
HTH

Bob

"Maki" wrote in message
...
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?

--
Maki @ Canberra.AU

Expiry mm/yy and validation
 

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?

--
Maki @ Canberra.AU


"Bob Phillips" wrote:

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?

--
__________________________________
HTH

Bob

"Maki" wrote in message
...
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?

--
Maki @ Canberra.AU

Expiry mm/yy and validation
 

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

--
__________________________________
HTH

Bob

"Maki" wrote in message
...
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?

--
Maki @ Canberra.AU


"Bob Phillips" wrote:

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?

--
__________________________________
HTH

Bob

"Maki" wrote in message
...
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?

--
Maki @ Canberra.AU

Expiry mm/yy and validation
 

I haven't done VBA with Excel 2007 but I can give it a try...
--
Maki @ Canberra.AU


"Bob Phillips" wrote:

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

--
__________________________________
HTH

Bob

"Maki" wrote in message
...
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?

--
Maki @ Canberra.AU


"Bob Phillips" wrote:

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?

--
__________________________________
HTH

Bob

"Maki" wrote in message
...
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?

--
Maki @ Canberra.AU