+ Reply to Thread
Results 1 to 3 of 3

Userform task monitor

  1. #1
    Forum Contributor
    Join Date
    08-22-2013
    Location
    Sheffield
    MS-Off Ver
    Excel 2010
    Posts
    161

    Userform task monitor

    Hi everyone,

    It's more of a task I've set myself to get a Userform that "monitors" the progress when running macros - not a bar though, it's done through labels.

    I've got it working and when i step through it, everything's is fine.. but when it runs without stepping, it'll only show the first label caption, then the next time it flashes all labels (5 of them) are complete.

    I have the UserForm ShowModal = False.

    There are 5 separate labels, and the code goes like; (probably better ways of doing the below.. but i just wanted to get it working first)

    Please Login or Register  to view this content.
    When the form first starts it sets label1.caption to Task 1..

    Any help on this would be great, thanks!

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431

    Re: Userform task monitor

    Try adding a repaint to your code

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    08-22-2013
    Location
    Sheffield
    MS-Off Ver
    Excel 2010
    Posts
    161

    Re: Userform task monitor

    Thanks Andy, i'll try it now.

    I don't think I've ever seen Repaint before!

    **It works, thanks again mate. Legend
    Last edited by jsneak; 01-03-2020 at 08:54 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 10-17-2017, 10:36 PM
  2. Replies: 0
    Last Post: 03-18-2014, 04:49 PM
  3. Userform fails to load unless excel application opened on left hand monitor !
    By D.A.S in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-19-2014, 04:10 PM
  4. Userform in fullscreen on 2nd monitor
    By promoboy2 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-27-2012, 07:40 AM
  5. Set Userform to Monitor Resolution
    By DCSwearingen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-15-2007, 04:07 PM
  6. resize userform image to fit on any monitor
    By timspier in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-05-2006, 01:50 AM
  7. Replies: 0
    Last Post: 04-28-2005, 11:31 PM

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