Linking the value of two (or more) cells in Excel

[NickSlash]

I'm pretty sure that something like this isn't possible (without custom coding it myself somehow) but maybe I'm wrong.

I'd like to link two (possibly more) cells together so that their values are all exactly the same.

The catch, I'd like to be able to edit said value from any of the linked cells.

Having a master value, and referencing that in each of the linked cells wouldn't work. (again, to my knowledge)

(backstory: I'm creating an app, using excel (wasn't my choice) and while I'd like to use something else, I get stuck with either not being able to store/interact with the data in a sane manner and creating a UI, so I've been soldiering on using Excel. It works... thats about all thats going for it...)

 

[NickSlash]

Nevermind, found a fairly simple way to do it in the end..

Using a master cell, and having the linked cells contain a reference to it

A1="Hello World"
A2="=A1"
A3="=A1"

Using the Worksheet_SelectionChange to capture the original formula, then when the Worksheet_Change event fires, the stored formula is read to get a reference to the master which is updated with the new value and the formula is then re-applied to the linked cell.