Well, he said "write it as" ... and you can, but as you noted, Excel will
auto-correct, removing what it consideres excess in this case <g

"Gary Keramidas" wrote:


that's not entirely correct, but the () will disappear when the code is entered.

TextBox.Value = Format(Date, "dddd mmmm yyyy")
--


Gary


"Lum" wrote in message
...
Hi Corey,

You can also write as

Textbox.Value = format(date(),"dddd mmmm yyyy")


"Corey" wrote:

Thanks Gary
I was close, but yet so far
"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
maybe

Textbox.Value = Format(Now, "dddd mmmm yyyy")

--


Gary


"Corey" wrote in message
...
TextBox16.Value = Now(Format(Date, "dddd mmmm yyyy"))

How is that suppose to be written ?