Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Expiry Date calculation | Excel Discussion (Misc queries) | |||
VBA For Expiry date | Excel Discussion (Misc queries) | |||
Expiry date | Excel Worksheet Functions | |||
Date of expiry - warning? | Excel Worksheet Functions | |||
formulation of an expiry summary | New Users to Excel |