Edit reference in a formula using vba

[yaghappak]

Hi All,

I want to do the following using vba and I am having a hard time to figure it out. Any help is highly appreciated.

The following steps can be done directly in the excel.
1. Enter a sample formula in cell "C1" i.e., "=A1+B1"
2. On cell "C1", press F2 and select reference B1
3. Press F5 and Goto dialog box is opened. You can see "B1" in the Reference textbox. Click OK.
4. Now you can see that there is a marquee around cell B1 and using arrow keys you can move the marquee that changes the reference "B1" to a new value and hence changes the formula.

My requirement is as follows:
I have a userform (that has a treeview and a button) which displays all the references (ie., A1, B1) of the formula in the treeview. Now if I select B1 and click on the button. I want to go to a state as indicated in Point#4 as indicated above.

Let me know if any other information is required.

Thanks,
yaghappak

[yaghappak]

Any inputs or any other way to achieve the same result?

Thanks,
yaghappak