+ Reply to Thread
Results 1 to 2 of 2

Screen flashes when Userform is processing the code

  1. #1
    Registered User
    Join Date
    02-16-2016
    Location
    bangalore
    MS-Off Ver
    365 proplus
    Posts
    4

    Screen flashes when Userform is processing the code

    I have one userform that is does multiple excel opening and closing for calculation and other reporting activity.

    For one submit button I have 6 excel sheets and 3 excel files are open and updated with the internal calculations in the background and then are closed. But during this process the excel files opening closing are visible to user in the userform background. This application is working fine in the earlier version of excel except for 2013 and higher.

    I have used Application.ScreenUpdating = False in all the places where internal calculations are processed.
    I have used Application.Visible = False so that only the main user form is visible all the time.

    I get many flashes of excel opening and closing. I need to avoid these flashes so that user does not feel any internal process happening.

    Can anyone help me?

  2. #2
    Valued Forum Contributor
    Join Date
    11-27-2013
    Location
    Brooklyn, NY
    MS-Off Ver
    Office 365
    Posts
    1,172

    Re: Screen flashes when Userform is processing the code

    i had the same issue but i realized that if you only insert:
    Please Login or Register  to view this content.
    in the button or command that opens the userform and fail to do so in the actual userform buttons you will experience the flashing. Meaning, it's not enough to disable the aforementioned functions once, you have to do so each time the userform runs a code.
    Of course it would be enough to enable the functions only once via this code:
    Please Login or Register  to view this content.
    I really hope this helps.
    Last edited by kosherboy; 04-16-2016 at 11:52 PM.

+ 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. Sheet-related processing causes Excel VBA Userform to stop processing Tab/Enter
    By Joaquin M Lopez Muno in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-22-2014, 03:02 PM
  2. Reduce processing time for processing multiple excel sheets
    By rexer231 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-06-2014, 09:25 AM
  3. [SOLVED] screen locks on userform screen sometimes
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-12-2013, 02:31 PM
  4. userform flashes on screen twice insted of once
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-16-2013, 10:13 AM
  5. Removing Screen Flashes while Macro is Running
    By Miskondukt in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-22-2013, 04:24 PM
  6. Screen flashes during VBA execution - does it happen in Office 2013?
    By tpbeta in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-13-2013, 05:23 PM
  7. [SOLVED] Can I Freeze Screen Update During Macro Processing?
    By Hercules1946 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-09-2012, 12:34 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