[RESOLVED] Experts: Excel VBA not in sync with chart engine

Hi all, :)

This one's for experts only:

No specific code for my problem (original TOO big).

Beforhand i would like to say that my program works like a swiss watch under Excel XP/2003. :thumb:

My problem is more general:

In my VBA code i manipulate a given line chart e.g. add a data label to the last data point of the chart. At a later point in the code i try to move this label to a different location.

Under XP/2003 this always works. But when run in 2007, it often happens that the data label has not been created by the chart engine yet and my program fails. Somehow VBA and the chart engine seem to be not in sync with one another. I'm fairly sure this is the problem. :sick:

What i am looking for is a method which ensures, that changes made to charts are executed (defined state) before VBA proceeds. At this moment i have no clue on how to resolve this. :confused:

Any ideas anybody? Maybe an event driven solution? :confused:

cheers,
Ray

Well community, i solved this one myself:

All i had to do is to actually .Select any graphic object i wish to manipulate. That syncs VBA to the the graphic engine of Excel.

Well, thanx to anyone who even bothered of at least viewing my request ....