+ Reply to Thread
Results 1 to 2 of 2

Excel 2013 and Excel 2016 still flickering after ScreenUpdating is off

  1. #1
    Registered User
    Join Date
    02-18-2017
    Location
    Dallas
    MS-Off Ver
    Windows 10
    Posts
    17

    Excel 2013 and Excel 2016 still flickering after ScreenUpdating is off

    My application relies on user forms rather than Excel worksheets. Worksheets are used for reports but with no calculations. I turn screen updating off when the workbook is opened and do not turn in on. In most instances there is no flickering but sometimes I still get a flicker. The flicker does not show moving from different worksheets or opening another database but will briefly turn off the on when using certain user forms.

    I have searched for a solution but nothing has worked. Any recommendation is very much appreciated.

    I am including a sample sub. The subs called from this code do not reference screen updating.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,431

    Re: Excel 2013 and Excel 2016 still flickering after ScreenUpdating is off

    .
    .
    I've not seen this done like this before :

    Please Login or Register  to view this content.
    Usually it looks like this :

    Please Login or Register  to view this content.
    The same with this :

    Please Login or Register  to view this content.
    However, if it works as is ... don't "fix" what ain't broken.


    Don't see any reference to a Form or Forms ???


    It is always good practice to reverse the [Application.ScreenUpdating = False] to [Application.ScreenUpdating = True] at the end of the macro.
    Otherwise, there is a possibility the user will close your workbook, go to another workbook and not be able to see updates in the other
    project.

+ 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. Replies: 1
    Last Post: 04-01-2017, 04:53 AM
  2. 2013 excel to 2016 excel now creating a bug
    By margal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-25-2016, 08:22 PM
  3. Problem running Auto_Open from add-ins in Excel 2013 and 2016
    By Cashgenerator in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-24-2016, 08:53 AM
  4. Excel 2013 Macros with Win 10 + Excel 2016
    By sunilvs24 in forum Office 365
    Replies: 2
    Last Post: 07-19-2016, 05:45 AM
  5. Application.ScreenUpdating Not Work in Excel 2013
    By JLousada in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-16-2016, 01:40 PM
  6. Macro From Excel 2013 Not Working in 2016
    By tm1238 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-08-2016, 04:39 PM
  7. Excel 2013 user form is flickering when it wasn't in Excel 2010
    By Janis Rainis in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2015, 01:33 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