Invalid "format string" argument in Format fuction

[jjk]

Hi,

I was wondering if there is any way to check for invalid "format
string" argument in the Format function.
As far as I can see it accepts all string combinations. Is there any
exception handling or boounds check that I can place here.
I ask this because I have to wrap the format functionality and want to
watch out for any side effects.

Thanks,
Jayant

Ref from Help:

Format Function
Returns a Variant (String) containing an expression formatted according
to instructions contained in a format expression.

Syntax:
Format(expression[, format[, firstdayofweek[, firstweekofyear]]])

expression - Required. Any valid expression.
format - Optional. A valid named or user-defined format expression.
firstdayofweek - Optional. A constant that specifies the first day of
the week.
firstweekofyear - Optional. A constant that specifies the first week of
the year.

 

[Leith Ross]

Hello Jayant,

You can include an Error handler in your code.

EXAMPLE;

Sub FormatData()

On Error Goto FormatError

Text = Format(<String>, <Format>)

Exit Sub

FormatError:

MsgBox "The Format specified is Invalid", vbOKOnly + vbCritical

End Sub

In the code, "FormatError:" is a Line Label and must not haveany spaces
before it.

Sincerely,
Leith Ross

 

[jjk]

Thanks Leith.

I was wondering if there is any list/formula for invalid formats.
The Format method works for any gibberish specified as format without
throwing an exception or error.

Regards,
Jayant

 

[Tom Ogilvy]

VBA help has a list of valid characters and symbols and what they are used
for. In xl97 at least, there are several help topics with lists depending
on what you are formating - numbers, dates.