Option Explicit
sub testme01()
with activesheet.range("e11")
.value = date
.numberformat = "mmmm dd, yyyy"
end with
end sub

But if you want a shortcut to enter today's date, you can use ctrl-;
(control-semicolon). You'll have to format the cell the way you want, though.

==
and the shortcut for entering the current time is ctrl-: (control-colon).



npereira wrote:

Hello all,

I am trying to find out what code to add to a command button to insert
todays date formated as " October 17, 2004 " in Cell E 11.

Please let me know.

regards,

Nelson

--
npereira
------------------------------------------------------------------------
npereira's Profile: http://www.excelforum.com/member.php...o&userid=10799
View this thread: http://www.excelforum.com/showthread...hreadid=269988

--

Dave Peterson