Hi

I am pulling in currency exchange rate external data from a web site... no
problems and storing the information on a worksheet.

I have a userform with txtboxes that are linked to each of the cells. When
the user form loads, the txtbox shows the currency exchange rate data
imported in from the web site...agian no problems.

I want to have a cmdbutton on the userform to update the data, i'm using:-

ActiveWorkbook.RefreshAll

but my question is the actual refresh will no take place until the userform
is closed. How can i make the refresh data run whilst the userform is
showing? Is this possible. I would like to click the command button to update
the data within the worksheet and show the updated rates within each of the
linked txtboxes on the userform without having to close the form down and
re-open.

Hope you can help.

TIA