Re: $$Excel-Macros$$ processor to slow for proper sequential processing of vba code ?

2011-09-07 Thread John Holland
other 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" wrote: > > >> application.enableevents=false > >> cod

Re: $$Excel-Macros$$ processor to slow for proper sequential processing of vba code ?

2011-09-06 Thread ashish koul
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

Re: $$Excel-Macros$$ processor to slow for proper sequential processing of vba code ?

2011-09-06 Thread dguillett1
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

Re: $$Excel-Macros$$ processor to slow for proper sequential processing of vba code ?

2011-09-06 Thread John Holland
> > -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

Re: $$Excel-Macros$$ processor to slow for proper sequential processing of vba code ?

2011-09-05 Thread dguillett1
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

$$Excel-Macros$$ processor to slow for proper sequential processing of vba code ?

2011-09-05 Thread John Holland
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