0 Members and 2 Guests are viewing this topic.
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