user form goes "blank" inside its borders

  • sometimes when i run code under a command button on a pop-up user form, the contents of the userform go "blank"
    (i.e., border stays on, so you can see that the form is still there, but the contents are all "white"-you cannot read/see any of the content...


    ?what could be done to prevent this from happening (presently, i just have the mouse cursur displaying while code is running?


    thank you.

  • Re: user form goes "blank" inside its borders


    Probably because your code is 'blocking' the form refresh... Add a 'DoEvents' statement somewhere.


    If you post your code, a more detailed answer can be given.

  • Re: user form goes "blank" inside its borders


    in further testing, i still loose the contents of the userform (seems the longer the code runs-based on a fitler, etc.


    here's the code i added:
    '...


    thank you

  • Re: user form goes "blank" inside its borders


    What's the point of the For ... Next loop?


    It's simply looping for 150,000 iterations, calling DoEvents every 1,000 loops. What happens in the reminder of the code/

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!