+ Reply to Thread
Results 1 to 9 of 9

Excel shapes flicker when Screen Updating turned back on

  1. #1
    Registered User
    Join Date
    11-08-2019
    Location
    Broward, FL
    MS-Off Ver
    360
    Posts
    5

    Excel shapes flicker when Screen Updating turned back on

    Hello fellow Excel enthusiasts,

    I have a small problem I've been trying to figure out for several days and can't seem to find a solution. I'm hoping someone here has come across this issue and can provide some guidance. The issue I am having is as follows. I have an Excel userform with a listbox that simply switches from the current sheet to another sheet then switches back. The problem is the shapes on the current page flicker at the end of this code. I turned off screen updating at the very beginning and turned it back on at the end of this short code so I don't understand why this is happening. Does this happen to anyone else? Is there a solution for this or am I stuck with it? Below is a copy of the code, any help is appreciated.

    Private Sub ListBox1_Click()
    Application.ScreenUpdating = False

    Sheets("Full scope Summary").Select
    Sheets("Summary").Select
    Application.ScreenUpdating = True
    End Sub

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Excel shapes flicker when Screen Updating turned back on

    have you tried manipulating the code to run under different lines? eliminated some? added others? more than likely, the screen updating has nothing to do with it. that is meant to reflect changes that connected to the screen itself. thus, the name of the method.

    my guess is that it's a simple glitch in excel. after all, office products are not the best in the world. have you done any searches like this one?

    https://www.google.com/search?q=exce...lecting+sheets

  3. #3
    Registered User
    Join Date
    11-08-2019
    Location
    Broward, FL
    MS-Off Ver
    360
    Posts
    5

    Re: Excel shapes flicker when Screen Updating turned back on

    vba_php, Thanks for your help but there's really not much I can change in the code. It is as basic as it gets but for some reason the shapes I am using as "buttons" flickers when screen updating is turned back on. I tried running the search you suggested but couldn't find anything.

  4. #4
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Excel shapes flicker when Screen Updating turned back on

    what about this search?

    https://www.google.com/search?q=exce...ing+flickering

    there aren't too many answers with regarding weird things that happen with software. the world is so stupidly complex, thanks to corporations of the world, that really ANYTHING is possible. and they don't even care, nor have they for quite some time. they are OK people, they simply do not have the TIME to care. they do their best. but the truth of the matter is, that, more than likely there is no answer to your issue.

  5. #5
    Registered User
    Join Date
    11-08-2019
    Location
    Broward, FL
    MS-Off Ver
    360
    Posts
    5

    Re: Excel shapes flicker when Screen Updating turned back on

    I still couldn't find a solution but will continue searching for one. Thankfully, the rest of my code works fine but having it flicker at the end is less than ideal. In any case, thanks for your input.

  6. #6
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    6,057

    Re: Excel shapes flicker when Screen Updating turned back on

    Why do you need to select the other sheets before coming back to the first one?

    Setting screenupdating back to True forces a screen redraw, which is why you see the flicker.
    Rory
    I drink, and I know things

  7. #7
    Registered User
    Join Date
    11-08-2019
    Location
    Broward, FL
    MS-Off Ver
    360
    Posts
    5

    Re: Excel shapes flicker when Screen Updating turned back on

    Great question Rory, The code I provided is just an incredibly streamlined version of the actual code which switches sheets, performs an advanced filter and returns to the original sheet with the data. The code works fine except for the flicker at the end when screen updating redraws the shapes I have on the sheet with macros assigned. While troubleshooting the problem I realized it happens only when I switch sheets.

  8. #8
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    6,057

    Re: Excel shapes flicker when Screen Updating turned back on

    Why do you think you need to switch sheets to do that?

  9. #9
    Registered User
    Join Date
    11-08-2019
    Location
    Broward, FL
    MS-Off Ver
    360
    Posts
    5

    Re: Excel shapes flicker when Screen Updating turned back on

    Oh man! I didn't realize I could get it done without switching sheets. Thanks for your feedback. Even though the code was working you made me rethink it slightly and I got it working without switching sheets.

+ 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 2013 screen flicker during Ctrl+C
    By nnemrac in forum Excel General
    Replies: 3
    Last Post: 02-10-2020, 12:39 AM
  2. Can Excel run vba without updating the screen or causing it to flicker?
    By Modify_inc in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-03-2019, 02:10 PM
  3. Excel Chart not Updating after Macro (Automatic is turned on)
    By scotth73 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2017, 08:25 AM
  4. Excel 2016 screen flashing between two workbooks despite screen updating turned off
    By Cumberland in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-29-2016, 03:07 PM
  5. Screen Flicker - EXCEL 2013 Only
    By A_Pass in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-19-2014, 11:31 AM
  6. Screen Flicker
    By BuzzT in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-07-2011, 11:22 AM
  7. screen flicker
    By mark kubicki in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-21-2005, 09:06 PM

Tags for this Thread

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