Hi all,
I have a list of products in a number of rows.
If the user clicks a button, a webscrape is started for each of the items in the rows.
To make sure the user understands excel is still working, I start a very simple userform saying "Working, please wait" as vbModeless and unload it at the end of the code.
However, somehow waiting for the webresults to return takes a few seconds at which Excel decides to say "Not Responding" - it pops back to life if the results are gathered and the code continues, however, the userform disappears (unloads) without that having been triggered by the code.
What can I do to prevent this?
Thanks,
Jasper
Bookmarks