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

How is that suppose to be written ?

maybe

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

--


Gary


"Corey" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> TextBox16.Value = Now(Format(Date, "dddd mmmm yyyy"))
>
> How is that suppose to be written ?
>
>

Thanks Gary
I was close, but yet so far
"Gary Keramidas" <GKeramidasATmsn.com> wrote in message
news:(E-Mail Removed)...
maybe

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

--


Gary


"Corey" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> TextBox16.Value = Now(Format(Date, "dddd mmmm yyyy"))
>
> How is that suppose to be written ?
>
>

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
> news:(E-Mail Removed)...
> maybe
>
> Textbox.Value = Format(Now, "dddd mmmm yyyy")
>
> --
>
>
> Gary
>
>
> "Corey" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > TextBox16.Value = Now(Format(Date, "dddd mmmm yyyy"))
> >
> > How is that suppose to be written ?
> >
> >
>
>
>
>

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

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


Gary


"Lum" <(E-Mail Removed)> wrote in message
news:E0682B54-3962-4445-A079-(E-Mail Removed)...
> 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
>> news:(E-Mail Removed)...
>> maybe
>>
>> Textbox.Value = Format(Now, "dddd mmmm yyyy")
>>
>> --
>>
>>
>> Gary
>>
>>
>> "Corey" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > TextBox16.Value = Now(Format(Date, "dddd mmmm yyyy"))
>> >
>> > How is that suppose to be written ?
>> >
>> >
>>
>>
>>
>>

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" <(E-Mail Removed)> wrote in message
> news:E0682B54-3962-4445-A079-(E-Mail Removed)...
> > 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
> >> news:(E-Mail Removed)...
> >> maybe
> >>
> >> Textbox.Value = Format(Now, "dddd mmmm yyyy")
> >>
> >> --
> >>
> >>
> >> Gary
> >>
> >>
> >> "Corey" <(E-Mail Removed)> wrote in message
> >> news:(E-Mail Removed)...
> >> > TextBox16.Value = Now(Format(Date, "dddd mmmm yyyy"))
> >> >
> >> > How is that suppose to be written ?
> >> >
> >> >
> >>
> >>
> >>
> >>
>
>
>