Liam
I' m having the same problem with
"Wrong number of arguments or invalid property assignment" on the word
"Format" in the following code:
txtDate.Text = Format(Date, "mm/dd/yy")
similar to your
fmtDate = Format(Date, "mmm-yy")
(A difference is that I don't have anything like "Dim fmtDate As String
"). But what do you mean by a Format() method "hidden away in a little
corner" of the workbook? Or, if anyone else knows what else could be
causing the problem, I would appreciate the assistance
John





--------------------


When I compile the code I get the if highlights *Format* and I get the
following error


Compile Error: