Function to Move TEXT Object dynamically ?

[#1]

Hello Every one,

I want to move Text object dynamically based upon Selection from List Box.

e.g. List Box contains 8 Country

1. Japan

2. Germany

3. USA

4. UK

5. China

6. Russia

7. Taiwan

8. France

If some one selects ONLY Japan or ONLY USA or ONLY Germany or any ONE of the anove Country, Postion of the TEXT Object will be x=230 & Y=100

However, if Some one Select Multiple Country,  JAPAN Text Object will be at x=230 & Y=100,  and USA will be x=260 & Y=120 and so forth so on.

Please note:

1. I am not sure if there is any function that I can use to move these text object dynamically
2. I am also not sure if there is better way to move the object dynamically.

I appreciate any insight in this matter.

[Anonymous]

Moving object is possible by creating a macro which would evaluate the conditions, and assign position parameters.

I think it is better to create multiple text boxes in the appropriate positions, and conditionally show only one at a time.

Regards,

Michael

[#3]

hmmmm. I am still new bee, so Macro is long way to go.

I will explore second option but that would require very complex IF Condition.

I appreciate, if you can provide me basic syntax to get going. I suppose it would be something like,

TEXT object # 1=>   if (Country='US')

TEXT object # 2=>   ? ? ?  ( assuming some one select US & JAPAN)

TEXT object # 2=>   ? ? ?  ( assuming some one select US & JAPAN  & GERMANY)

[Anonymous · Accepted solution]

See attached example.

Notice the tesxt boxes text and also show conditions.  Hope it helps...

Regards,

Michael

[#5]

Michael,

You are brilliant. Hats off. This example opens up my imagination

THANK YOU !

[Anonymous]

Hi Michael,

The solution is amazing, we tried the same with graphs instead of  text boxes it is not working fine, can you please suggest how to proceed on this.

Thank you