Results 1 to 3 of 3
  1. #1
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    custom color palettes for forms (Excel 2003)

    Hi all,
    I have customized the color palette for my workbook but this doesn't seem to apply to the colors I have access to when creating a form in the editor. Is this 'by design' or is there a way to make the two the same? I'd like to set the BackColor (shown as "&H00FF0000&", for example) property of a form to one of these custom colors but the palette displayed is not the same as the one I see in the worksheet from the color drop down list.

    It seems I can only set each form element's back/forecolor via code (using RGB). Is that how it works?

    Deb

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: custom color palettes for forms (Excel 2003)

    You can use the RGB function via VB or you can use the properties window in VB (F4) which has a pallette to choose colors from.

    If you have certain colors you want to use in a userform via VB you can add the colors to variables or constants and use them...

    Steve

  3. #3
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: custom color palettes for forms (Excel 2003)

    Yeh, rats I figured you'd say that <img src=/S/bummer.gif border=0 alt=bummer width=15 height=15>. I was hoping the two palettes were linked (that'd make sense wouldn't it?) but I'll go ahead and set the RGB manually as you suggested.

    Thnx,
    Deb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •