changing date

[chief]

i have a code set up currently like this in thisworkbook open:

Range("K3") = Now()
Range("K3").NumberFormat = "mmmm d, yyyy"

is there a way to have it so that in userform6, my commandbutton1 whe
clicked will return the value back to the originally saved date and no
today's date.

reason being it is for an invoice program, when they use a new one i
comes out with todays date which is good, but the next day or next wee
they can go back to look at the invoice. when this happens it doesn'
reflect the actual date of the invoice, rather the date at that poin
in time they look at the invoice.

thank

 

[Paul B]

Chief, use something like this to check to see if there is anything in K3,
if the date is already there it want put a new one




If Sheet1.Range("K3").Value = "" _

Then Sheet1.Range("K3") = Date
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **