+ Reply to Thread
Results 1 to 3 of 3

VBA: Progress bar not showing

  1. #1
    Registered User
    Join Date
    02-14-2011
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007
    Posts
    1

    VBA: Progress bar not showing

    I'm running into a problem with a userform that I designed to be a progress bar. Basically, I put the code I wish to execute into the initialize event for the userform, and certain values on the userform are supposed to change as the code runs. However, while the code is executing (correctly), the area inside the form is just showing up as white. Everything's set to visible, and screenupdating is on. Does anyone know why this might happen? Is there some way to force it to refresh the view of the userform in the code?

    Thanks to anyone who can help!

  2. #2
    Forum Expert Colin Legg's Avatar
    Join Date
    03-30-2008
    Location
    UK
    MS-Off Ver
    365
    Posts
    1,255

    Re: VBA: Progress bar not showing

    Hi,

    Yes, use the userform's Repaint method to ensure it is displayed correctly.
    If you're stuck, post your code and we can show you where to add it in.

    Hope that helps...
    Hope that helps,

    Colin

    RAD Excel Blog

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: VBA: Progress bar not showing

    ScreenUpdating will not affect the userform
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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