Good day all, i used the formula =if(y5="yes",if(d5="",now(),d5),""), but every time i click on a different tic box the time changes, I need the click on a tic box and the date and time gets stamped on the line with out changing when i click on a different tic box on the same sheet, can you assist
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Static timestamp using check box
0
Discussion
Please include a sample file that shows what you are trying to do.
MRVMV (rep: 52) Oct 12, '16 at 7:38 am
Answers
1
As MRVMV said, you will need to include a sample file to be able to more specifically help you.
However, in general, I can tell you that you will need a macro to do this and it could look something like this:
Sub insert_time()
Range("A1").Value = Now()
End SubYou can run this to see how it works but it will, of course, have to be altered in order to work in your workbook. When you upload the sample file I can give you more specific help.