+ Reply to Thread
Results 1 to 7 of 7

Word 2003 - ComboBox within UserForm, different custom colours for each value

  1. #1
    Registered User
    Join Date
    10-12-2012
    Location
    Hampshire, England
    MS-Off Ver
    Word and Excel 2003 and 2010
    Posts
    2

    Word 2003 - ComboBox within UserForm, different custom colours for each value

    Hi, i'm new to the forums.

    I'm in no way an expert in VBA, I've searched the internet with no luck with a change I'm trying to do to a Word 2003 document template.

    I'm using a Userform to populate a document template. I need help with one specific ComboBox, where I want to assign each of the values with a different custom colour, using RGB? These are not standard colours.

    Once selected and I click to 'Update Document', the selection needs to populate the specific text with its colour within the Header and Footer only of the document.

    I work alongside developers who haven't an answer for this. Unfortunately I'm unable to attach the code. I'm getting to the stage of writing the colour codes into my 'Code of Practice' document and the users having to complete this task manually which isn't best practice.

    I'd appreciate any help.

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Word 2003 - ComboBox within UserForm, different custom colours for each value

    You can associate the colours with the combobox values in various ways. The attached shows one way.
    Attached Files Attached Files
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Registered User
    Join Date
    10-12-2012
    Location
    Hampshire, England
    MS-Off Ver
    Word and Excel 2003 and 2010
    Posts
    2

    Re: Word 2003 - ComboBox within UserForm, different custom colours for each value

    Morning Paul, thanks for replying.

    Unfortunately the document is blank when I open it.

  4. #4
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Word 2003 - ComboBox within UserForm, different custom colours for each value

    Well, yes, but that's because all it has is a userform with a combobox and some demo code.

  5. #5
    Registered User
    Join Date
    12-07-2012
    Location
    malaysia
    MS-Off Ver
    Excel 2003
    Posts
    1

    Question Re: Word 2003 - ComboBox within UserForm, different custom colours for each value

    Hi,

    Doesn't seem like there is any coding or combo box in the file. I can't see anything, unless there is a hidden function?

    Please clarify. Thank you.

  6. #6
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Word 2003 - ComboBox within UserForm, different custom colours for each value

    As I said in post#4, the document has a userform with a combobox and some demo code. You can access them via Alt-F11.

  7. #7
    Registered User
    Join Date
    01-28-2013
    Location
    sydney, austalia
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Word 2003 - ComboBox within UserForm, different custom colours for each value


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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