Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
checking cell format
if i have code that formats a cell:
Format(cell, "ddd" & Chr(10) & "mm/dd") how would i test cells to find if the format is applied? -- Gary |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
checking cell format
First, that code doesn't format a cell, it returns a string with the
desired format. If you then apply that string to a cell, it may or may not be parsed correctly. To format the cell, you'd want: cell.NumberFormat = "ddd" & Chr(10) & "mm/dd" To test the cell, check the .NumberFormat property: MsgBox cell.NumberFormat = "ddd" & Chr(10) & "mm/dd" will display True/False in the message box. In article , "Gary Keramidas" <GKeramidasATmsn.com wrote: if i have code that formats a cell: Format(cell, "ddd" & Chr(10) & "mm/dd") how would i test cells to find if the format is applied? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
checking cell format
ok, thanks je
-- Gary "JE McGimpsey" wrote in message ... First, that code doesn't format a cell, it returns a string with the desired format. If you then apply that string to a cell, it may or may not be parsed correctly. To format the cell, you'd want: cell.NumberFormat = "ddd" & Chr(10) & "mm/dd" To test the cell, check the .NumberFormat property: MsgBox cell.NumberFormat = "ddd" & Chr(10) & "mm/dd" will display True/False in the message box. In article , "Gary Keramidas" <GKeramidasATmsn.com wrote: if i have code that formats a cell: Format(cell, "ddd" & Chr(10) & "mm/dd") how would i test cells to find if the format is applied? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format Checking | Excel Discussion (Misc queries) | |||
Checking a cell conditional format | Excel Worksheet Functions | |||
Spell Checking with checking cell notes | Excel Discussion (Misc queries) | |||
Checking a Date format | Excel Programming | |||
checking the format of a string in a cell | Excel Programming |