Looking for a macro which enters date of today when ticking a tickbox
Hello Excel(lent) users,
I have created a list and in column T I have created Tickboxes. I want to connect these boxes to a macro, so when a user ticks one of these boxes, I want the next field in the same row (in column U) to be filled with today’s date in such a way that the date is fixed and doesn’t change tomorrow or at a later stage.
So when I tick the box in T3, I want today’s date to be entered in U3.
I know how to connect the macro to the tick box, but the code of the macro I am not able to create myself.