Results 1 to 6 of 6

Make label visible once macro finishes run

Threaded View

  1. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Make label visible once macro finishes run

    UserFormName.LabelcontrolName.Visible = True
    With the appropriate names for the Userform and Label substituted.

    Suggested without the benefit* of seeing your existing code - but that, generally, is how it is done.

    *(Even if you integrate that line into your code am willing to bet your next post says all the labels appear at the end rather than when set visible)
    Last edited by cytop; 04-27-2017 at 07:20 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro to scroll to activecell and make visible in middle of screen
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-27-2015, 02:38 PM
  2. a macro has to make visible a new macro-button
    By Xavier Derille in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-16-2015, 03:15 PM
  3. Make macro button visible/invisible as per user name
    By nayanthara in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-15-2014, 03:46 AM
  4. With a move label macro, prevent label from moving onto another label
    By SocratesJC in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-09-2014, 12:34 AM
  5. Label is visible before enabling macro even though its visibility was set to false.
    By Sangram Bhosale in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-16-2012, 07:43 AM
  6. Macro to Hide/Make Visible Pivot Items
    By az! in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-30-2011, 06:18 AM
  7. Macro finishes faster when left clicking during execution
    By Martin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2006, 06:50 AM

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