Here is an example of the code (PastePicture is a function to paste
the graph from the clipboard into the image control; the code comes
originally from the website of Stephen Bullen and is too long to
include here).
What may happen is that the Image2-control is not filled with the
correct Chart,
Thanks dguillett1 for your assistance, but i am not sure this is the
right track. Perhaps it is my lack of knowledge, but i cannot this
code to work. What i need is to make sure that some code is completely
excecuted before a next part of code is processed. How can i control
the VBA code to wait
I am not understanding. Perhaps a sample file dguillett1 @gmail.com
-Original Message-
From: John Holland
Sent: Tuesday, September 06, 2011 2:14 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ processor to slow for proper sequential
processing of vba code ?
Thanks
Hi John,
please try this see if it helps
after u copy and paste first image add
Application.CutCopyMode = False
this way u can check if loop is working properly or not
use below statement to make it wait for 5 second then resume ur code
Application.Wait Now + TimeValue(00:00:05)
also
I am running into the problem that some VBA code is not processed in
time before a next statement can be executed. For example i want to
put a certain Excel graph into the Windows Clipboard and then echo it
in an image control on a userform. After that comes a 2nd graph in
another image control
application.enableevents=false
code block
application.enableevents=true
-Original Message-
From: John Holland
Sent: Monday, September 05, 2011 3:28 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ processor to slow for proper sequential processing
of vba code ?
I am