Check box to over ride formula in another cell

[MXSYYC]

Hello everybody,

I'm very new to visual basic and i need some help.

I have attached my worksheet (i think)

At the moment, the red cells in column D pull values from different sheets in the workbook. I want to Put a checkbox
in column A beside each red cell, so that when clicked, will allow me to manually enter a number into the cell.

I hope that makes sense.

I searched the forum and tried a couple of examples that were already mentioned but i can't seem to figure it out.

Thanks for any help you can give me!

Max

[Richard Buttrey]

Hi, and welcome to the forum

What's stopping you entering a number directly? Why do you need a checkbox? Why indeed do you need VBA?

If you want to retain the formula but be able to vary it then why not change the formula e.g. D22 to say

=IF(A22="",Equipment!C25,A22)

Then if you want to override the formula enter a number in A22.

[MXSYYC]

Thanks Richard!!

That is great!!!