I have an Excel Application where I display a UserForm Panel.
Initially right before the UserForm.Show statement, I do the
Application.ScreenUpdating=TRUE
Reason being, is because when the UserForm Panel is displayed and the person
slides the panel around on top of a Chart
This prevents the non-refresh BLUEISH images sliding all over the Chart from the
displayed UserForm Panel.
The ( TOUGH QUESTION ) is this:
In this UserForm Panel, I have a list of items in a ListBox
When I select a particular item from the list
Then in the VBA code for this ListBox, I do the
Application.ScreenUpdating=FALSE to turn off the Chart flickering of the current
VBA code being executed
After when this VBA code is completed, then I do the
Application.ScreenUpdating=TRUE
PROBLEM is this, everytime when selecting a item from this ListBox
It causes the Chart to flicker at each completion of the VBA code, because of
the Application.ScreenUpdating=TRUE
If I do the Application.ScreenUpdating=FALSE in the ListBox selection code and
not do the Application.ScreenUpdating=TRUE at the end of the code.
Every time when I do select an item from this ListBox, it is so clean ( no
flickering at all )
However when I move/slide the UserForm Panel around, the non-refresh BLUEISH
images are all over the Chart...( SIGH )
How can I fix this, so it can be very clean for each item selected from this
Listbox and yet prevent non-refresh BLUEISH images ?
Any ideas ?