Make column editable without deleting the formula and default value

[sandhya16]

Hi,

I have a column that i am calculating based on another column values so it has some default values and formula in it initially but i am want to make this column editable by making user enter their own values but i dont want to delete the formula.

With the help of VBA?

 

[sandhya16]

Hi,

I have a column that i am calculating based on another column values so it has some default values and formula in it initially but i am want to make this column editable by making user enter their own values but i dont want to delete the formula.

With the help of VBA?

Please help me with this-

Asking this-
Leave the formula in your cell
if the user selects the cell the formula disappears
the user types a value or not, up to them
the user selects another cell
if the cell is empty the formula re-appears



I have range E15:E74 having formula that i want to allow editing as well if selected otherwise leave it default formula.
E15 :E29 has one formula and E30:E74 have same formula.

 

[sandhya16]

Please help with this problem.

Please help me with this-

Asking this-
Leave the formula in your cell
if the user selects the cell the formula disappears
the user types a value or not, up to them
the user selects another cell
if the cell is empty the formula re-appears



I have range E15:E74 having formula that i want to allow editing as well if selected otherwise leave it default formula.
E15 :E29 has one formula and E30:E74 have same formula.