Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Correct code
TextBox16.Value = Now(Format(Date, "dddd mmmm yyyy"))
How is that suppose to be written ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Correct code
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 ? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Correct code
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 ? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Correct code
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 ? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Correct code
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please correct for me this code | Excel Programming | |||
Please correct for me this code | Excel Programming | |||
Please Help Correct my code | Excel Programming | |||
Code is not correct | Excel Programming | |||
Help to correct code | Excel Programming |