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 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
--
----------------------------------------------------------------------------------
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
