+ Reply to Thread
Results 1 to 3 of 3

Userform help - Caption will not change

  1. #1
    Forum Contributor PY_'s Avatar
    Join Date
    09-23-2008
    Location
    Houston
    MS-Off Ver
    Office 2016
    Posts
    289

    Userform help - Caption will not change

    I have a userform that pops up and stays up while other macros run. I would like to have the text on the userform change as it progresses through the macros. Why is it that the attached userform will not update the text if you run straight through it? BUT, if I F8 my way through it, the userform changes text like i want it to.

    I have the 2-second pause in there just for this example so it will not just run through it quickly.



    Here is the code if you dont want to view the file:

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by PY_; 02-22-2011 at 09:29 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    08-23-2009
    Location
    Hampshire, UK
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    328

    Re: Userform help - Caption will not change

    If you add

    Please Login or Register  to view this content.
    after each new text, the caption will change.

  3. #3
    Forum Contributor PY_'s Avatar
    Join Date
    09-23-2008
    Location
    Houston
    MS-Off Ver
    Office 2016
    Posts
    289

    Re: Userform help - Caption will not change

    Thanks! I would have never found that one.

+ 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