Hi,
You could try a message box, in the appropriate place, which says something
like:
"Press OK when data is loaded."
The macro always pauses when a message box is displayed, and resumes when OK is
pressed.
Regards - Dave.
> Date: Mon, 15 Sep 2008 06:55:17 -0700> Subject: $$Excel-Macros$$ Pause a
> Macro> From: [EMAIL PROTECTED]> To: excel-macros@googlegroups.com> > > I have
> a macro that pulls information from a database. Once all the> information is
> in Excel it then does some calculations. The problem is> that the information
> coming from the database takes a while to load,> but the macro keeps going so
> I get an error because it's trying to do> calculations on data that isn't
> there yet. I've tried> Application.Wait(Now + TimeValue("0:00:10"))> but that
> even stops the data coming from the database to stop loading.> Is there a way
> to get the data to keep loading while the Macro pauses?> >
> _________________________________________________________________
It's simple! Sell your car for just $40 at CarPoint.com.au
http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fsecure%2Dau%2Eimrworldwide%2Ecom%2Fcgi%2Dbin%2Fa%2Fci%5F450304%2Fet%5F2%2Fcg%5F801459%2Fpi%5F1004813%2Fai%5F859641&_t=762955845&_r=tig_OCT07&_m=EXT
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
