Results 1 to 2 of 2

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

Threaded View

  1. Jul 13th, 2011, 04:32 AM #1
    RaytracerFFM
    RaytracerFFM is offline

    Thread Starter
    New Member RaytracerFFM's Avatar
    Join Date
    Jun 2010
    Location
    Frankfurt, Germany
    Posts
    15

    Resolved [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.

    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.

    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.

    Any ideas anybody? Maybe an event driven solution?

    cheers,
    Ray
    Last edited by RaytracerFFM; Jul 19th, 2011 at 04:37 AM. Reason: Refined question

    If your query has been Solved, please mark it as such in the top menu via Mark Thread Resolved under Thread Tools

    Was a post helpful? Then you might care to rate it by clicking Rate This Post on the lower left hand side of it
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width