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