linking cells in vba instead of pulling the value

[bkuchen]

I have a VBA code that pulls a value from a single cell on a separate tab. Instead of just pulling the value (ex. 3.44589348) is there a way to have it pull the value as a link to the other
tab? It still would display the number but if you click on the cell it would display =Sheet2!A1 (for example).

Thanks!!

[clabhart]

Yes you could use the following if for example you want cell A1 in sheet1 to have the same value as cell A1 in sheet2

Please Login or Register  to view this content.

This will give you the same value but not the formula. If you want the formula use

Please Login or Register  to view this content.

[bkuchen]

Thank you for your response! I don't need the same formula I just need my value on Sheet1 to display =Sheet2!A1 instead of just the number. The numbers on Sheet2 are hard coded so they have no formula. I am wondering if there is another ending like ".Value" that will do that. The goal is then if the numbers change on my other sheets, I wont have to re-run my macro again since they will be linked from the start. Does that help?

[clabhart]

Ok I'm not sure how to do that though you could achieve the same result by adding a workbook change function

Please Login or Register  to view this content.

Here when ever there is a change in sheet2 the value of A1 in sheet1 will equal the value of A1 in sheet2

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.