Selection from which object..?

[PradeepReddy]

Hi,

Is there anyway to get the Object Name/ID, Field Name and Field Value from which object that field was selected?

Using 'Ccurrent Selection box' we can see only the selected field name and it corresponding value.

EX: I have a field "Region", present in the List Box, Bar Chart and Pivot Table.

a) If I select the field "Region" from the List box, I have to populate "List Box Name/ID" in a Text Box

b) If I select the Bar Chart, I have to show case "Bar Chart Name/ID" in a Text Box.

Thanks in advance.

[#2]

I hope only through macro its possible.

regards

Mahesh T

[PradeepReddy]

If you have any Idea abount the releavent functions used in macro, pls share the same.