Make column editable without deleting the formula and default value

sandhya16

New Member
Joined
Jun 8, 2015
Messages
34
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?
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

sandhya16

New Member
Joined
Jun 8, 2015
Messages
34
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

New Member
Joined
Jun 8, 2015
Messages
34
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,911
Messages
5,471,468
Members
406,764
Latest member
ExcelMaker007

This Week's Hot Topics

Top