Excellent!

This works like I needed it to.

Now, 1 more question. Is it possible to set the sheet to automaticl
insert todays date when I save the document? Instead of having to clic
that button?

This is for an Invoice Template I am setting up.

Thanks


JMay Wrote:
Private Sub CommandButton1_Click()
Range("E11").Value = Format(Date, "mmmm dd,yyyy")
End Sub


"npereira" wrote in message
...

Hello all,

I am trying to find out what code to add to a command button t
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


--
npereir
-----------------------------------------------------------------------
npereira's Profile: http://www.excelforum.com/member.php...fo&userid=1079
View this thread: http://www.excelforum.com/showthread.php?threadid=26998