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 > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > 5. Excel Tips and Tricks athttp://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- 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 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
