Date and Time Stamp Excel 2007

[estellejane1971]

Hello
I have added check boxes to a workbook. Is it possible to set it up so that the Date and Time is showed when the check box is ticked?
Thanks in advance

[6StringJazzer]

Welcome to the Forum!

Yes it is, but where do you want the time and date to be shown?

It requires VBA code (macros). The specific code depends on what type of checkboxes are you are using. There are two types, the older Form checkboxes and the newer ActiveX checkboxes.

It would be best if you attached your file.

[estellejane1971]

I have attached an example of the file. I would like the date and time to appear above the Management Meeting for example when the check box is ticked and the date to remain static.Example Doc.xlsx I have used the the form controls check box not the ActiveX.

Thanks

Welcome to the Forum!

Yes it is, but where do you want the time and date to be shown?

It requires VBA code (macros). The specific code depends on what type of checkboxes are you are using. There are two types, the older Form checkboxes and the newer ActiveX checkboxes.

It would be best if you attached your file.

[6StringJazzer]

Here is a solution that replaces your controls with ActiveX controls. I do not use Form controls and the coding is not as straightforward for them. If that matters to you and you require Form controls then hopefully someone else will provide that solution.

(Note that it is not necessary to quote the entire post you are responding to.)

[estellejane1971]

Thank you so much for your help. It works but doenst look as "pretty" as the form controls check box as I want to colour the cells and it leaves a white background. But apart from thats its perfect.

Thanks

[6StringJazzer]

It is possible to set the background as transparent on these controls. I have done so in this attachment. Go into Design mode, right-click on the control, and set BackStyle as Transparent.

They are pretty now