Time stamp cells on single mouse click

[SJV9]

Hi everyone!

Can someone help me on how I could get a time stamp on column G each time cells on column B is clicked?

I tried inserting both commandbuttons or labels and set them to invisible so the text underneath is the thing to be seen. I got it to stamp the time on a single click alright however I would also want to be able to select the value on the cell underneath the label/button.

 

[SJV9]

For instance, only Rows 1 to 15 of columns B and C have data on them while Rows 16 down to 65,000 are still blank (won't have data until the next day). I need the time stamp to work only on cells that have data, in this case row 1 to 15 of columns B and C only until the other rows are filled with data the following day will the time stamp work again for the addidtional rows.