Results 1 to 3 of 3

Thread: Get Excell Cell color ?

  1. Jun 30th, 2004, 08:56 AM #1
    andrzej
    andrzej is offline

    Thread Starter
    New Member
    Join Date
    Jun 2004
    Location
    Poland
    Posts
    10

    Get Excell Cell color ?

    Could you possibly explain me or show some part of code:
    How can I get active cell color form Excell sheet.

    Thanks in advance
    Reply With Quote Reply With Quote
  2. Jun 30th, 2004, 09:23 AM #2
    Ecniv
    Ecniv is offline
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343
    I think its selection.interior.color

    Easiest way is to record a new macro in excel, change the colour of the cell, stop recording and view the code. It should tell you how to get the number for the colour.


    Vince

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...
    Reply With Quote Reply With Quote
  3. Jul 1st, 2004, 04:58 AM #3
    alex_read
    alex_read is offline
    Evil Genius alex_read's Avatar
    Join Date
    May 2000
    Location
    Espoo, Finland
    Posts
    5,538
    Ecniv is spot on, it's :

    VB Code:
    1. Private Sub CommandButton1_Click()

    2.     MsgBox Cells(1, 1).Interior.Color

    3. End Sub

    Please rate this post if it was useful for you!
    Please try to search before creating a new post,
    Please format code using [ code ][ /code ], and
    Post sample code, error details & problem details
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width