hi there. I am trying to create a macro button that puts a time stamp in a cell. The use case is I administer the timing for running races. As people finish I put their time in a  spreadsheet. What I would like is a button in the cell that when clicked, puts the time in that cell, and the button disappears. I’ve got 90% of the way there with a button that enters the time stamp in the cell where the cursor is, which makes it a bit fiddly. What I want is 20 buttons for 20 runners against each of their numbers that all I do is click the button and the time stamp enters and the button disappears. Thanks for any advice!

​hi there. I am trying to create a macro button that puts a time stamp in a cell. The use case is I administer the timing for running races. As people finish I put their time in a  spreadsheet. What I would like is a button in the cell that when clicked, puts the time in that cell, and the button disappears. I’ve got 90% of the way there with a button that enters the time stamp in the cell where the cursor is, which makes it a bit fiddly. What I want is 20 buttons for 20 runners against each of their numbers that all I do is click the button and the time stamp enters and the button disappears. Thanks for any advice!  Read More

​