Code completes before "refreshall" completes

[staynerm]

Here are a few lines of my code:

    ActiveWorkbook.RefreshAll
    Call populateComboBox
    MsgBox ("Done!")

The combobox on line 2 is populated with data that is refreshed on line 1. Only problem is, line 2 doesn't wait to execute until line 1 is complete. So, my combobox is populated and I get a "Done!" message before my data is done refreshing.

Is there a way I can make the code pause and wait for the data to refresh before it continues?

 

[VoG]

Maybe

ActiveWorkbook.RefreshAll
Do Until Application.Calculate = xlDone
DoEvents
Loop
    Call populateComboBox
    MsgBox ("Done!")

 

[Andrew Poulsom]

What are you refreshing? If it's a Query is its BackgroundQuery property set to False?

 

[staynerm]

What are you refreshing? If it's a Query is its BackgroundQuery property set to False?

I am refreshing a data connection. Basically I am refreshing data in a table and want to update the combo box based on the new table data. Thanks!

 

[Andrew Poulsom]

And is the BackgroundQuery property set to False?

 

[staynerm]

And is the BackgroundQuery property set to False?

Ahhhh! I see. I unchecked "Enable background Refresh" under properties on my data connection and it works exactly like I want it to now. Easy fix (if you know what you are doing).

Thanks!!!