Application.Screenupdating = False Is Not Enough !

[Logit]

.
There is a severe page / screen flicker when selecting CONTRACT # from the dropdowns on pages :
MasterData - ABC, MasterData - DEF, MasterData - GHI, in cells : B2, G2, L2.

The code searches for the contract # from the dropdown from the DATABASE sheet. When located,
various cells on the sheet are populated.

The issue is the extreme annoying flicker during the cell populating.

APPLICATION.SCREENUPDATING is not sufficient to stop this flicker, which leads me to believe the
culprit is in the coding itself.

I've run out of ideas.

Thank you for looking and hopefully finding a solution.

Please Login or Register  to view this content.

[TMS]

You should avoid selecting worksheets and ranges. You don't need to select anything in order to operate on it. That would almost certainly avoid the flickering.

[FlameRetired]

I'm not a VBA guy, but would the second call to Application.ScreenUpdating = False (4th line down before Resume Next) cause any anomalies?

[Logit]

.
Thank you for reviewing ...

I did remove these lines where ever they appeared but that did not stop the flickering :

Sheet4.Activate
Sheet4.Range("B2").Select

I've used Application.Screenupdating = False only once at the top of the code and Application.Screenupdating only once at the bottom.
Still no success.

????

[TMS]

Untested, but stuff like this

Please Login or Register  to view this content.

Could be this

Please Login or Register  to view this content.

[Logit]

.

TMS ... tried your suggestion. No go.


Thought this would do but no ...

Please Login or Register  to view this content.

[bakerman2]

Please Login or Register  to view this content.

[Logit]

.
bakerman

Thank you for contributing.

I edited just the first part of the macro to see it work. Regretfully, it is not copying the data and pasting as needed.

Here is what I did :

Please Login or Register  to view this content.

[Kenneth Hobson]

I doubt it would help but maybe try an API solution?

If things go amiss when testing an API solution, closing Excel and/or rebooting may be needed.

e.g.
In a Module:

Please Login or Register  to view this content.

Test the 2 methods in same Module or another:

Please Login or Register  to view this content.

[Logit]

.
Kenneth

Thank you for your interest.

I am unable to follow an API approach. But I do thank you !

[bakerman2]

That's because all your SrchStrng are returning empty strings due to the merged cells.

Loop through your code using F8 and you'll see.

Unmerge all cells, remove Datavalidation. Then merge cells back and add Datavalidation.

Problem solved.

[Logit]

.
Thanks bakerman2


I followed your instructions to unmerge, remove Datavalidation, etc.

Then this is how I implemented the suggested code :

Please Login or Register  to view this content.

What have I done wrong ?

Note: the sheet name is MasterData-ABC.

[bakerman2]

Something with the sheetname I guess because when I do this it works.

Please Login or Register  to view this content.

[bakerman2]

No screen flicker anymore.

Please Login or Register  to view this content.

[Logit]

.

Please Login or Register  to view this content.

My copy of the workbook is not cooperating ...

[Logit]

.
Disregard.

Your second post works fabulously !

Thank you so much bakeman2 !

[Logit]

.
Thank you everyone for your assistance !

It is very much appreciated.

Cheers and good evening.

[bakerman2]

Glad you got it working.

Thanks for rep+. Much appreciated.

[TMS]

You're welcome. Thanks for the rep.