iLogic that uses vlookup table to edit text labels

[Anonymous]

Hello,

I have a situation where one drawing file is used for multiple parts and the only difference when a new drawing is made is the text labels are edited for the specific part we're using.  I would like a VBA (ilogic solution) where the text labels on the drawings are populated by a vlookup from Excel based on iProperties in the title block.

For example, consider a drawing that has 5 text labels "1", "2", "3","4","5" and an iProperty field called "Entity" that is displayed in the title block.  When I open that drawing and change the title block iProperty parameter "Entity" to LSB123, the text labels should change as per example Excel table below.  i.e., "1" becomes "G100", "2" becomes "G102", etc.

thanks,

Ryan 

[MechMachineMan]

How are the text labels put in?

Is it simply a text box?

Is it a sketched symbol?

Does it have a leader?

Are they actually balloons with a different style?

Do the text labels have style overrides attached to them?

Are there any other objects input similarly that might be accidentally changed?