Help in macro code to stop code running for certain time

Hi all,

I have myself a macro code does various things but in the middle of it it tells a microsoft query table to refresh itself. It then brings up a userform afterwards. The problem I am having is that bringing up the userform is stopping the query table from refreshing (it won't refresh until I manually close the userform).

I have tried the application.wait function but this doesn't actually stop the code - it just pauses it for x seconds (my mouse pointer goes into the 'waiting' mode) so the table still doesn't refresh itself.

What I am after basically is somehow that I can stop the code completely and then start it again 2 or 3 seconds afterwards?

Can anyone help?

OK thanks - I've copied that in exactly and replace the italics with my table name and it comes up with a syntax error. Does it need ""?

Many thanks I will give that a go tomorrow

Hi, it now comes up with a runtime error 424 'object required' and highlights your bit of code when I debug it.

Here is my code in full:

Please Login or Register  to view this content.

OK Data is the query table - I have named it Data

I've tried that and it comes up with a runtime error 9 'subscript out of range'?

Anyone got any thoughts on this?

Just to recap, the code is:

Please Login or Register  to view this content.

It comes up with a runtime error 9 'subscript out of range'