I have a worksheet where information from inputboxes from another sheet is deposited. I have arranged the information into nice neat rows. The problem is:
I want a checkbox on each row to strikeout the text on that row if the checkbox on that row is 'checked'. There are 365 rows on this worksheet in use. The solution I have requires that each checkbox 'code area' be filled with - (something along the lines of
If text is strikeout = true then strikeout =false
else strikeout = true
this works but I have to write a macro for each Checkbox for each row. Is there a way to do this without having to write 365 macros?
Thanks
I want a checkbox on each row to strikeout the text on that row if the checkbox on that row is 'checked'. There are 365 rows on this worksheet in use. The solution I have requires that each checkbox 'code area' be filled with - (something along the lines of
If text is strikeout = true then strikeout =false
else strikeout = true
this works but I have to write a macro for each Checkbox for each row. Is there a way to do this without having to write 365 macros?
Thanks