+ Reply to Thread
Results 1 to 4 of 4

Userform disappears if excel stalls for a second

  1. #1
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Userform disappears if excel stalls for a second

    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
    Please click the * below if this helps

  2. #2
    Forum Contributor
    Join Date
    09-17-2014
    Location
    UK
    MS-Off Ver
    2007
    Posts
    117

    Re: Userform disappears if excel stalls for a second

    Very hard to say without seeing the code.

    Have you tried stepping through the code but skipping the webscrape lines to see if this is a direct result of excel hanging during the retrieval?

  3. #3
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Userform disappears if excel stalls for a second

    Can't you run the webscraping async?

  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Userform disappears if excel stalls for a second

    Quick Example:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. excel stalls when leaving cell after data entry
    By bobmayers in forum Excel General
    Replies: 1
    Last Post: 01-31-2014, 05:39 PM
  2. [SOLVED] Userform Stalls when jumping from one form to another
    By edilly in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-14-2014, 11:25 AM
  3. Userform in Excel 2013 disappears while switching an active workbook behind
    By blackarrow in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-17-2013, 09:08 AM
  4. [SOLVED] USERFORM DISAPPEARS ON EXCEL MINIMIZE
    By Ian Digby in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-25-2006, 04:55 AM
  5. VBA Script in Excel Stalls Out On It's Own After Opening Secondary Excel File
    By SilentThunder in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-19-2005, 06:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1