| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get data from Excel-cell and check format
Hi! I am writing a macro for a spreadsheet. You are supposed to write two
dates into the spreadsheet in two different cells. When a button is pressed the program shall read the text in the cells and check to see if they are in the right format e.g. 2006-06-14 and not 06-06-04 i.e. YYYY-MM-YY. Help!!!!!!!!!!! -- I am very thankful for any fast assistance! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get data from Excel-cell and check format
Why does the sheet have TEXT in these cells? Use data validation to
check for date, and set the format of the cells to the format you want. SamanthaK wrote: Hi! I am writing a macro for a spreadsheet. You are supposed to write two dates into the spreadsheet in two different cells. When a button is pressed the program shall read the text in the cells and check to see if they are in the right format e.g. 2006-06-14 and not 06-06-04 i.e. YYYY-MM-YY. Help!!!!!!!!!!! -- I am very thankful for any fast assistance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel could not find the data ....check format | Excel Discussion (Misc queries) | |||
| Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
| Cell Format Check | Excel Programming | |||
| check the cell format by function or vba code | Excel Programming | |||
| Check cell contents then format as locked | Excel Programming | |||
Hybrid Mode
