Select a Checkbox to enable a macro on the same row

Mstg007

Active Member
Joined
Dec 30, 2013
Messages
383
I am trying to figure out how to apply a toggle box that enables a macro to run on the current row it is selected on.

I have an example spreadsheet that has 2 worksheets. The first Worksheet for the current Jaunary 2018, and the second worksheet is for the January 2017.
The column A1 is labled by DAY and column B1 is labled by DESCRIPTION.

This would be for worksheet January 2018.
A2 is Day 1 and the B2 Worked on Car
A3 is Day 2 and the B3 Worked on Boat
A4 is Day 3 and the B4 Worked on House
A5 is Day 4 and the B5 Worked on House
A6 is Day 5 and the B6 Worked on Garage
etc.

This would be for worksheet January 2017.
A2 is Day 1 and the B2 Worked on Boat
A3 is Day 2 and the B3 Worked on Car
A4 is Day 3 and the B4 Worked on House
A5 is Day 4 and the B5 Worked on Garage
A6 is Day 5 and the B6 Worked on Garage
etc.
I want to be able to put a check box toggle in C2, then drag it down to the last day. As I select the check box,
I would like to see what was done on that day from the January 2017 worksheet. If i un-check it, it will go back
and show what was previously there.

I hope I did not confuse anyone on this. Thank you for your help and guidance!
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top