Finding VBA and Function code

[ukdane]

I'm sat looking at a worksheet someone else has created, and am wondering how/if it is possible to trace a cell.

What I mean by this is if for example I have a cell with a number in it, if I activate that cell, is there something I can do to see if that cell is linked to any formula?

Is there a similar function to see if it is linked with some vba code?

Cheers, yer ponderer.

[Jan Karel Pieterse]

Open the Formula auditing toolbar and use the buttons trace dependents and trace precedents. That does not do VBA though.

[nst1107]

Open the VBE and use the Find command to look for that cell's address in the code.

[georgiboy]

Open the VBE and use the Find command to look for that cell's address in the code.

Thats what i would do, remember that the cell in question could also be referenced as Cells(1,1) as well as Range("A1").