+ Reply to Thread
Results 1 to 4 of 4

Boring UserForm Colors

  1. #1
    Registered User
    Join Date
    08-21-2013
    Location
    Jacksonville, FL, USA
    MS-Off Ver
    Excel 2010
    Posts
    61

    Boring UserForm Colors

    Running Yosemite on iMac. Background colors are VERY rudamentry in design of a UserForm MessageBox. I see many different styles of message boxes elsewhere in Microsoft applications and wonder, is anything else available to enhance UserForm appearance? Can I import from somewhere else?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Boring UserForm Colors

    I don't know how to import a different palette for use with the design GUI, but you can assign any color you want if you do it in code.

    To set a background color of a user form, for example, add this Sub to your UserForm code:

    Please Login or Register  to view this content.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    08-21-2013
    Location
    Jacksonville, FL, USA
    MS-Off Ver
    Excel 2010
    Posts
    61

    Re: Boring UserForm Colors

    Hi Jazzer, Thanks for your reply. Is there code to go gradient, and format borders? r/Phil

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Boring UserForm Colors

    You can set border color and foreground text color, IIRC. But you can only use solid colors, not gradients. Not as powerful as fill colors for cells. For background, you could embed an image to provide a gradient background, see attached.
    Attached Files Attached Files

+ 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. Command Button colors (userform)
    By ChemEBA in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-21-2013, 06:30 AM
  2. Automate boring repetitive task
    By SpenceBasics in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-05-2012, 10:34 PM
  3. Automating a boring process
    By blakrapter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-15-2012, 03:03 AM
  4. changing vba userform colors
    By Josh_123456 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-05-2007, 03:43 PM
  5. [SOLVED] Pls help me to any quickest alternative from this boring shortcut
    By rony4icab in forum Excel General
    Replies: 7
    Last Post: 05-18-2006, 10:35 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