Checkbox relating to datestamp.

[seanexcels]

Hello,

I am having trouble creating a checkbox which when checked datestamps another cell in yymmdd format. Basically the whole column A will be all checkboxes and the whole column, lets say, C will be where I want the datestamp to go. I am creating a contact management sheet. I appreciate all efforts to help. Thanks.

-Sean

[Loz]

You would have to have a short piece of code for each checkbox to insert the current date. For example, assumming A1 has the checkbox number 1, then the code might be. . .

Please Login or Register  to view this content.

This would have to be repeated for CheckBox2 (for cell A2 & C2) etc.

A simpler idea may be to get users to double-click on the cell in column C when they've actioned that contact and then a short piece of code inserts the current date in that cell.

Right-click on the worksheet tab, select view code, and insert the following . . .

Please Login or Register  to view this content.

This avoids having to set up numerous checkboxes and associated code.

[seanexcels]

Thanks a lot Loz! I too like the second idea you proposed. I tried it and it works very effectively within my spreadsheet. Cheers to you!

-Sean