Format Function In VBA

[Transformer]

When we start typing a function then its description is displayed with it....in case of Format$, it can be seen that it is declared as String and for Format there is no data type means Variant.
As of now, i dont have any example for format function but difference can be seen in the following example:

Left(NULL,3) returns NULL and Left$(NULL,3) throughs a run time error.

Because a Variant can be Null but String can not be NULL.