+ Reply to Thread
Results 1 to 5 of 5

Userform flickers

  1. #1
    Registered User
    Join Date
    04-03-2012
    Location
    Stockholm
    MS-Off Ver
    Excel 2003
    Posts
    33

    Userform flickers

    Hi,
    I have a userform with several textboxes. I use Repaint to update the userform. That makes the userform flicker. Is there any other way to update a userform?
    Stefan

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Userform flickers

    No. Why do you need to update it - is it a modeless form that you are updating in a loop?
    Remember what the dormouse said
    Feed your head

  3. #3
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Userform flickers

    You don't usually need to repaint explicitly, the form should do it without.

    Can you post the code you have?

  4. #4
    Registered User
    Join Date
    04-03-2012
    Location
    Stockholm
    MS-Off Ver
    Excel 2003
    Posts
    33

    Re: Userform flickers

    Here is a summary......I didn't have Repaint before. Then the Userform was showing nothing. After I added Repaint it showed my data but it flicker.

    Please Login or Register  to view this content.

  5. #5
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Userform flickers

    It is because it repaints when finished. The problem is the 40k loop

    Try Replacing testform.Repaint with DoEvents
    Last edited by Kyle123; 08-29-2012 at 09:43 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1