Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: VBA colorindex

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Clearwater, FL
    Posts
    46
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Does anyone know where I can find a list of valid codes for colors in Excel? Either the 2-digit number or the long text name would be fine.

    Thanks for any help!

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Have a look under VBA help for ColorIndex.

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    Clearwater, FL
    Posts
    46
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I tried that. There's nothing under "colorindex" either in the Index or under Find.

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hmm, i just found it OK. Try typing in colorindex in the VBA code window, highlighting it and pressing F1. If you don't get anything you might not have the VBA help files installed.

  5. #5
    New Member
    Join Date
    Mar 2002
    Location
    Clearwater, FL
    Posts
    46
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Well, whaddya know, it worked. Now how come when I used the help index to search for "colorindex", it did NOT find that? I never thought of using F1 on the highlighted value.

    Thanks!

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Personally, I never use the index- either F1 or the Find tab of the help form.

  7. #7
    New Member
    Join Date
    Mar 2002
    Location
    Clearwater, FL
    Posts
    46
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    good idea. I'll use F1 from now on. The Find didn't find it either for me.

  8. #8
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You're right, it doesn't appear unless, under the Contents tab, you're referencing Microsoft Excel VB.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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