Thread: Correct code
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default Correct code


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 ?