+ Reply to Thread
Results 1 to 3 of 3

Excel 2013 user form unable to set label text color in VBA code

  1. #1
    Registered User
    Join Date
    12-02-2011
    Location
    east coast, USA
    MS-Off Ver
    Excel 2010
    Posts
    14

    Excel 2013 user form unable to set label text color in VBA code

    File is attached. Run the form and put in different values for passwords. I want "Label_Messages" control text to show in Red. My code does not get the job done.

    Thanks for helping.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Excel 2013 user form unable to set label text color in VBA code

    If you set the label control Enabled to false, the font color is set to grey to default and you cannot change the font color. Since it is a "Label control", not sure why you need to disable it.

  3. #3
    Registered User
    Join Date
    12-02-2011
    Location
    east coast, USA
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Excel 2013 user form unable to set label text color in VBA code

    Very good JieJenn.

+ 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. Excel 2013 user form is flickering when it wasn't in Excel 2010
    By Janis Rainis in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2015, 01:33 PM
  2. Replies: 8
    Last Post: 03-08-2015, 10:02 AM
  3. Correct vba code for text boxes in user form
    By newqueen in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 05-27-2013, 09:38 PM
  4. VBA User Form Label won't show
    By ker9 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-29-2011, 09:57 AM
  5. Filling form fields via worksheet dropdowns, user update via form, change form color
    By Demosthenes&Locke in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-11-2010, 08:58 AM
  6. In need to format a label in an user form
    By jobro in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-05-2008, 08:07 AM
  7. Excel color palette on user form?
    By Shane Henderson in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-02-2005, 05: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