Make VBA code that posts a cells formula as a value

[Jyggalag]

Hi all,

I currently have the following setup:

I have some numbers in column C and D, and I use a simple sum() formula in column B.

However, I also want to be able to click on the cells in column B and see the value in the formula bar. But I want to keep the formulas in the meantime.

What I would like is for some code that makes it so all the values in column A are automatically = all the values in B (but in values, so not in formula).

This means that I essentially want this end result:

But I naturally want it to automatically update if the values in column B changes as well.

Is there some sort of VBA code that can alter column A to make this possible?

Would be HIGHLY appreciated! Thank you so much all

 

[Fluff]

Duplicate to: Have formula data appear as text, maybe VBA solution?

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.