Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I check if a cell is formatted as a date in Excel VB?
I'm using MS Office Excel 2007; trying to write VB function to update a cell
content with a date; would like to first determine if that cell already has been formatted as a date; otherwise do not update |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I check if a cell is formatted as a date in Excel VB?
Alex,
This statement checks if the format contains a day in the format for cell A1: If InStr(Range("A1").NumberFormat, "d") 0 Then ' Cell is formatted as a date End If Greetz, Gertjan Alex@LM wrote... I'm using MS Office Excel 2007; trying to write VB function to update a cell content with a date; would like to first determine if that cell already has been formatted as a date; otherwise do not update |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I check if a cell is formatted as a date in Excel VB?
Thank you, Gertjan. This is just what I needed!
"Gertjan Huiskes" wrote: Alex, This statement checks if the format contains a day in the format for cell A1: If InStr(Range("A1").NumberFormat, "d") 0 Then ' Cell is formatted as a date End If Greetz, Gertjan Alex@LM wrote... I'm using MS Office Excel 2007; trying to write VB function to update a cell content with a date; would like to first determine if that cell already has been formatted as a date; otherwise do not update |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell formatted as date won't change | Excel Discussion (Misc queries) | |||
Extracting date from Date and Time formatted cell | Excel Discussion (Misc queries) | |||
When using & and a date-formatted cell in a formula I lose the for | Excel Worksheet Functions | |||
how do i add 1 year to a date formatted cell? | Excel Worksheet Functions | |||
Converting 'General' formatted cells to Text formatted cell using. | Excel Worksheet Functions |