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 can you share your code with us.
On Tue, Sep 6, 2011 at 6:52 PM, dguillett1 <dguille...@gmail.com> wrote:
> 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 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 with processing until the physical part of a code
> has been executed properly, i.e. put an Excel graph into the Windows
> clipboard and paste it into an image control (HERE THE CODE NEEDS TO
> WAIT UNTIL THIS PART IS PROCESSED), then continue with putting a next
> graph into the clipboard and paste that one into another image control
> (HERE THE CODE NEEDS TO WAIT UNTIL THIS PART IS PROCESSED), and so on.
> any further suggestions are most welcome,
> cheers,
> JH
>
> On 5 sep, 15:55, "dguillett1" <dguille...@gmail.com> wrote:
>
>> 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 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 and so on. What happens is that the statements
>> for the 2nd graph are not executed properly because the second graph
>> is not put into the Clipboard in time to be echoed into the 2nd image
>> control. This 2nd image control shows the first graph in stead of the
>> 2nd one.
>>
>> My question is if there is a way to make sure that some code is
>> executed properly before continuing with other code?
>>
>> thanks for your kind assistance,
>> JH
>>
>> --
>> ------------------------------**------------------------------**
>> ----------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :http://twitter.com/**
>> exceldailytip <http://twitter.com/exceldailytip>
>> 2. Join our LinkedIN group
>> @http://www.linkedin.com/**groups?gid=1871310<http://www.linkedin.com/groups?gid=1871310>
>> 3. Excel tutorials
>> athttp://www.excel-macros.**blogspot.com<http://www.excel-macros.blogspot.com>
>> 4. Learn VBA Macros
>> athttp://www.quickvba.**blogspot.com<http://www.quickvba.blogspot.com>
>> 5. Excel Tips and Tricks
>> athttp://exceldailytip.**blogspot.com<http://exceldailytip.blogspot.com>
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><>**<><><><><><><>
>> Like our page on facebook , Just follow below linkhttp://
>> www.facebook.com/**discussexcel-
>> <http://www.facebook.com/discussexcel->Tekst uit oorspronkelijk bericht niet
>> weergeven -
>>
>> - Tekst uit oorspronkelijk bericht weergeven -
>>
>
> --
> ------------------------------**------------------------------**
> ----------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/**
> exceldailytip <http://twitter.com/exceldailytip>
> 2. Join our LinkedIN group @
> http://www.linkedin.com/**groups?gid=1871310<http://www.linkedin.com/groups?gid=1871310>
> 3. Excel tutorials at
> http://www.excel-macros.**blogspot.com<http://www.excel-macros.blogspot.com>
> 4. Learn VBA Macros at
> http://www.quickvba.blogspot.**com<http://www.quickvba.blogspot.com>
> 5. Excel Tips and Tricks at
> http://exceldailytip.blogspot.**com<http://exceldailytip.blogspot.com>
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><>**<><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/**discussexcel<http://www.facebook.com/discussexcel>
> --
> ------------------------------**------------------------------**
> ----------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/**
> exceldailytip <http://twitter.com/exceldailytip>
> 2. Join our LinkedIN group @
> http://www.linkedin.com/**groups?gid=1871310<http://www.linkedin.com/groups?gid=1871310>
> 3. Excel tutorials at
> http://www.excel-macros.**blogspot.com<http://www.excel-macros.blogspot.com>
> 4. Learn VBA Macros at
> http://www.quickvba.blogspot.**com<http://www.quickvba.blogspot.com>
> 5. Excel Tips and Tricks at
> http://exceldailytip.blogspot.**com<http://exceldailytip.blogspot.com>
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><>**<><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/**discussexcel<http://www.facebook.com/discussexcel>
>
--
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com <http://akoul.blogspot.com/>
http://akoul.posterous.com/
*akoul*.wordpress.com <http://akoul.wordpress.com/>
My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
P Before printing, think about the environment.
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
