Use a checkbox to erase a cell's formula

[Timat124]

Hi,

I want to create a checkbox which when checked would delete the fomula that is already in a cell and therefore would allow manual changes. I did some research and couldn't find anything. Do you have any ideas on how to program something like this?

Best regards,

Matt

[PaulSP8]

Not really sure why you'd want to do that when you can just overwrite it, but...

I've attached an example workbook - The Checkbox toggles the formula in B1

The code for it lies in the Sheet1 code - If you check the box, it deletes it, if you uncheck it, it puts it back to give you both examples;

Please Login or Register  to view this content.

Hope that helps.

[Timat124]

I'm new to VBA coding, so I don't fully grasp your hole code. I copy pasted what you did on a new worksheet and linked a checkbox to B1, but the result that I got was "TRUE" and "FALSE". Do you know what my mistake is?

[Mrrrr]

It would help if you would attach the workbook you used to show us what you did and where the mistake was.

[PaulSP8]

I copy pasted what you did on a new worksheet and linked a checkbox to B1, but the result that I got was "TRUE" and "FALSE". Do you know what my mistake is?

You need to assign it to a Macro, right click on the Checkbox and then 'Assign Macro' - Don't worry about setting the control value for this one.