Saving checkbox change

Hi there,

I have this here code which changes cells to the strike through font when checked, but when the userform is unloaded, the strikethrough font effect changes back to what it was before.

How can I get the font to stay when the userform is unloaded?

Please Login or Register  to view this content.

Kind regards
Rob

Ah, solved this issue:

Please Login or Register  to view this content.

There shouldn't be an else statement to keep this permanent on the sheet. Just need to set check box to true based on the font value from the sheet.