+ Reply to Thread
Results 1 to 4 of 4

Changing the colours of a userform

  1. #1
    Registered User
    Join Date
    07-01-2007
    Posts
    32

    Changing the colours of a userform

    I would like to change the colour of a userform both the background colour and the font colour. However, in the colour property box I am met with &H00C0C0C0& (which is Grey). I can select some other colours but not the one I would like to use.

    I have tried inserting RGB(194,214,154) however I get the error 'Invaild proprty value'

    Grateful for any help you can offer.
    Last edited by artizan; 10-09-2008 at 11:12 AM. Reason: SOLVED

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    You are limited to the colours available in the Properties window of the UserForm
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650
    Hi, You could put the code in the Userform "Initialize" Event.
    Please Login or Register  to view this content.
    Regards Mick

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,441
    You can use code at run time.

    Or you can type the HEX value in the property window.

    In your case the value would be &H009AD6C2&

    In the immediate window use the following to give you the correct code

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

+ 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. Changing Cell colours
    By johncon in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-05-2008, 07:47 AM
  2. Changing column colours on a bar graph
    By cricket_stoner in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-17-2008, 06:01 AM
  3. Changing Cell Colours
    By JUBA in forum Excel General
    Replies: 5
    Last Post: 04-24-2007, 04:51 PM
  4. Calendar in UserForm changing size
    By kvo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2007, 07:07 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