Excel 2016 annoying object flickering

[ABSTRAKTUS]

Hi there,

Having searched a bunch of forums could not find any solutions how to prevent ActiveX objects from flickering. It even flickers while wrapped into manual calculation, events and screen updating set to false.

I have only got 3 cascading listboxes on the spreadsheet and the flickering I am experiencing while drilling down to the result is rather annoying. My business have just upgraded all PC's to 2016 package, but all the spreadsheets used to work flawlessly on 2010 version.

I'm tempted to call Office 2016 version the worst of all, as it is way too bugy.

Has anyone heard of the possible solution to stop that flicker? Update pack, Add-in, piece of VBA code, anything?

Thanks for sharing.

[Kyle123]

Just use forms controls

You're better off not using ActiveX controls on worksheets at all. They're incredibly unstable have a look here https://www.google.co.uk/webhp?sourc...eet%20controls and by using them, you're asking for trouble.

Forms controls are much more reliable - they're in the same dropdown as the ActiveX ones, but are designed for use on worksheets - so you don't run into any stability issues, you can do most of the same things with them too and you can use them without using code.

[ABSTRAKTUS]

Yes, but I wouldn't want to lose all that object formating that ActiveX can provide...

[Kyle123]

Horses for courses..

Unfortunately, you can't have your cake and eat it. ActiveX on worksheets have always been problematic

[ABSTRAKTUS]

Funny enough, I have re-created the spreadsheet with Form controls instead and it still flickers...

[Kyle123]

Then you need to post a sample workbook as something else is causing the issue - probably the code

[ABSTRAKTUS]

Attached with ActiveX controls. Needs to be tested on 2016 version.

[nigelog]

I don't get the flickering but I'm guessing its the method of loading the info

Windows 7 Professional 64 bit
Office 2016

[ABSTRAKTUS]

Hmm...

I'm running Office 2016 32 bit on Win 10 64 bit...

[Kyle123]

It's the method of loading the info. Try this:

Please Login or Register  to view this content.

I've used forms controls. but the code would only need minor tweaks if you wanted to use ActiveX

[ABSTRAKTUS]

Wow! Not a single flicker! Thanks Kyle!

What parts of code would need tweaking to adapt it on ActiveX objects? Interesting if they would still flicker...

[Kyle123]

They won't, and again using ActiveX controls on worksheets is asking for trouble

In a module

Please Login or Register  to view this content.

Then behind the worksheet:

Please Login or Register  to view this content.

[ABSTRAKTUS]

Your code is not just a million times quicker loading the listboxes, but also has eliminated that nasty flickering. Cheers Kyle!

[Kyle123]

Glad it helped Thanks for the Rep