Hi,
Can anyone help me? I need to unload & reload userform but there is flashing on the screen due to Screenupdating=False not working.
Please Login or Register to view this content.
Hi,
Can anyone help me? I need to unload & reload userform but there is flashing on the screen due to Screenupdating=False not working.
Please Login or Register to view this content.
You don't have to have an = True statement for it, as it automatically resets to true when it hits the End Sub (or Exit Sub).
You can also put an command button on form that will act as an escapePlease Login or Register to view this content.
May work....Please Login or Register to view this content.
Last edited by Parth007; 07-22-2015 at 04:13 AM.
Regards
Parth
I appreciate your feedback. Hit * if u Like.
Rules - http://www.excelforum.com/forum-rule...rum-rules.html
Hi Parth007,
You are misunderstood.
I am highlighting the issue Application.ScreenUpdating=False not working when unload & reload userform.
Ohh.. may be some other method to solve it... Experts
Does this help?
Please Login or Register to view this content.
Hi John,
It is same as before.
When I search a lot of samples, I got advised to run back Userform_Initialize. However, my Userform is to populate data to ListView which had also causing screen flashing few seconds to populate a lot of data. Then, the Total & Average for each column at the bottom rows has debug error.
That's why I am decided to Unload & Reload is to clear ColumnHeaders Sort in ListView. To make it same as when initializing.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks