Macro adaptation to work for multiple worksheets

[johnmitch38]

On the attached workbook, there 3 worksheets.

On "Days" worksheet, there is a macro to populate the time (column F) at which a user ticks the corresponding checkbox (column E)

I have two other worksheets (Nights, Sub-contractors) and I want the formula to work in exactly the same way for these worksheets.

I'm not sure how to adapt the macro so that the time populates on these two other worksheets.

[Greg M]

Hi there,

Take a look at the attached version of your workbook and see if it does what you need. It just needed the "CheckBox_Date_Stamp" macro to be assigned to all of the CheckBoxes on the other worksheets.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[johnmitch38]

Perfect - thank you - much appreciated.

[Greg M]

Hi again,

Many thanks for your feedback.

You're welcome - glad I was able to help.

Regards,

Greg M