+ Reply to Thread
Results 1 to 2 of 2

Sum up all cells that contain a color

  1. #1
    Forum Contributor
    Join Date
    10-03-2005
    Posts
    183

    Sum up all cells that contain a color

    I've made a macro which sums up all cells containing a certain color.


    Is there a way that I can make a userform to contain a list of all the colors (with the color itself) instead of the number?

    If so how?


    Thanks

  2. #2
    Tom Ogilvy
    Guest

    Re: Sum up all cells that contain a color

    Take a look at John Walkenbach's color picker

    http://www.j-walk.com/ss/excel/tips/tip49.htm

    this should get you started.

    --
    Regards,
    Tom Ogilvy


    "Ctech" <Ctech.223h1c_1138031402.9192@excelforum-nospam.com> wrote in
    message news:Ctech.223h1c_1138031402.9192@excelforum-nospam.com...
    >
    > I've made a macro which sums up all cells containing a certain color.
    >
    >
    > Is there a way that I can make a userform to contain a list of all the
    > colors (with the color itself) instead of the number?
    >
    > If so how?
    >
    >
    > Thanks
    >
    >
    > --
    > Ctech
    >
    >
    > ------------------------------------------------------------------------
    > Ctech's Profile:

    http://www.excelforum.com/member.php...o&userid=27745
    > View this thread: http://www.excelforum.com/showthread...hreadid=504050
    >




+ 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