Tim and date stamps for a checklist

[rkj1966]

Hello

I have looked around the forum for a possible solution to my problem, but either have not looked hard enough or i am unable to recognize the solution.

I want time and date (as of the time of clicking) when i click a checkbox in one cell to appear, and stay unchanged, in another cell. When it is not checked, or if it is unchecked again, the date and time have to disappear. And if clicked again, a new date and time set (as of the time of the new click) has to appear.

I have tried this solution:



A2 Format control (of CheckBox) -> Cell link set to:
$B$2

C2 (wherein time+date needed) set to
=IF(B2=TRUE;NOW();"")


But the now function is literally "now" i have discovered, and keeps the date and time updated to actual time. I need it to keep the time from when the checkbox was clicked

hope it is not too convoluted a description.

Thanks
Rene

[AndyLitch]

Put this in the worksheet code module. Any changes to column B will be time and date stamped in column C

Please Login or Register  to view this content.

[rkj1966]

Thx for reply :-)
Sorry i am not an experience excel user. Where do i find the "worksheet code module" ??

[AndyLitch]

Right click on the worksheet tab and select "View Code"

[satabp]

ALT+F11 and the click on the respective sheet (from the left hand side window - Project Explorer)

and then place the code suggested..

[BjarneHansen]

Hej skal den gemme på det tidspunkt når du klikker på en bestemt celle

[rkj1966]

Ja, når jeg klikker en checkbox, så skal tidspunkt (og også gerne dato) skives i et andet felt og dette skal som tekst, forblive uændret

[rkj1966]

AndyLitch. thanks for suggestion. I cannot get it to work. I put it in the code for the checklist-tab, where i want it to work. i think the problem is that the checkbox object kind of is not integrated in the B coloumn but kind of just flows over it. And if i make a change in the B coloumn below it gives an error and highlihts the first line in the code

[AndyLitch]

Ex1.xlsm

Try the attached example ...

[rkj1966]

Thanks a lot ... i will use that one :-)

[AndyLitch]

Your're welcome... Can you mark the thread as solved pls

[rkj1966]

Sure .. thanks to all

[rkj1966]

Andylitch
A detail that i needed, which your code does not support (AFAIK) is that when/if the B coloumn cells are removed the date in the corresponding C cell does not disappear. It will stay visible and change if new data is entered in B. Can that be added? I do not know how or if it is possible !