Using Marlett checkboxes in two separate columns each with corresponding date stamps

[JStreck]

Thanks to this thread: http://www.excelforum.com/excel-prog...ime-stamp.html

I was able to get one column to work perfectly. I double click a cell in the target column, it checks the cell, and it populates the date stamp in the correpsonding cell in the next column.

Now I'm stuck trying to figure out how to duplicate that exact same function for another column within the same worksheet. For example, the first column that contains the Marlett checkboxes is column G (G2:G) which populates a corresponding date stamps in column H. I would like to duplicate this function for column J (J2:J) with date stamps in column K.

Can this be done?


I'm using Excel 2010.

[protonLeah]

Please Login or Register  to view this content.

[JStreck]

Please Login or Register  to view this content.

Thanks for the quick response! Unfortunately, I used the code you suggested but it didn't work. I get no error, but none of the cells in the target ranges provide Marlett checks and don't trigger date stamps. The cells just become normal active cells when double clicked.

I tried it with and without adding the extra Or statement you provided in both sections. Neither variation seems to work. Here's what I've got right now:

Please Login or Register  to view this content.

[protonLeah]

Tested and works:

Please Login or Register  to view this content.

[JStreck]

Thank you, protonLeah! This works perfectly!