Dear All,

I am new in VBA excel and for one day I am fighting for the following problem:

I need to have a checkbox in cell F1, which does the following:

If it is checked, then the values in cells A1:E1 stay as they are and do not change.

If it is unchecked, the values are cleared (with .clearvalues) and in the cells A1:E1, the values of the cells G1:K1 are assigned accordingly. I hope you got what I mean and someone is willing to help.

Any ideas would be appreciated!

Thank you in advance!