Forum Discussion
Changing data value in Excel cell also overwrites function
I created a simple pounds and kilograms unit conversion. However when I try to change the value in the cell, it also overwrites the function. Is there any way to change the value without changing the...
That is not possible. A cell can contain a fixed value or a formula, not both.
But you can use VBA code to accomplish it.
See the attached workbook. You'll have to allow macros when you open it.
To view the code, right-click the sheet tab and select 'View Code' from the context menu.