You need to write a small macro:Sub UpDateDate()'' UpDateDate' made by MonikaS' D = CDate(FormatDateTime(Now, vbShortDate)) Range("B5").Value = DEnd SubAttach this to a graphic on your spreedsheet and each time you click the graphic the date will change to the current date in cell B5.HTHMonika
Well, he wanted a button to click on Without a button Crtl . (it's a dot) would insert the current date using the default datetime format.Monika
Dont worry doc i know you would have figured it out for me sooner or later
Information presented on this website is the opinion of the individual contributors and does not reflect the general views of the administrators, editors, moderators, sponsors, Cambridge University or the public at large.
The contents of this site are © The Naked Scientists®
2000-2014. The Naked Scientists® and Naked Science™ are registered