Results 1 to 33 of 33

Shading Shapes

Threaded View

Hood Shading Shapes 10-08-2009, 08:44 AM
romperstomper Re: Shading Shapes 10-08-2009, 08:48 AM
Hood Re: Shading Shapes 10-08-2009, 09:06 AM
romperstomper Re: Shading Shapes 10-08-2009, 09:11 AM
Hood Re: Shading Shapes 10-08-2009, 09:22 AM
romperstomper Re: Shading Shapes 10-08-2009, 09:31 AM
Hood Re: Shading Shapes 10-08-2009, 09:40 AM
romperstomper Re: Shading Shapes 10-08-2009, 09:43 AM
Hood Re: Shading Shapes 10-08-2009, 09:53 AM
Hood Re: Shading Shapes 10-08-2009, 01:01 PM
romperstomper Re: Shading Shapes 10-08-2009, 03:43 PM
Hood Re: Shading Shapes 10-12-2009, 07:37 AM
Hood Re: Shading Shapes 10-13-2009, 06:57 AM
romperstomper Re: Shading Shapes 10-13-2009, 06:08 PM
Hood Re: Shading Shapes 10-14-2009, 10:54 AM
Hood Re: Shading Shapes 11-06-2009, 10:54 AM
romperstomper Re: Shading Shapes 11-06-2009, 11:02 AM
Hood Re: Shading Shapes 11-06-2009, 11:24 AM
romperstomper Re: Shading Shapes 11-06-2009, 11:27 AM
Hood Re: Shading Shapes 11-06-2009, 11:31 AM
Hood Re: Shading Shapes 11-23-2009, 10:55 AM
shg Re: Shading Shapes 11-23-2009, 10:57 AM
Hood Re: Shading Shapes 11-23-2009, 11:47 AM
  1. #1
    Forum Contributor
    Join Date
    09-25-2009
    Location
    Indiana
    MS-Off Ver
    Excel 2003
    Posts
    156

    Shading Shapes

    I am trying to change the colors of some shapes based on a cell value like the code below

    Private Sub Worksheet_Change(ByVal Target As Range)
    If Range("$O$11").Value = "X" Then
        Worksheets("Print").Shapes("Oval1").Fill.ForeColor.SchemeColor = 2
    Else
        Worksheets("Print").Shapes("Oval1").Fill.ForeColor.SchemeColor = 3
        End If
     End Sub
    I have an unknown number of shapes as well as an unknown number of sheets. One document may have thirty shapes, while the next may have two hundred shapes.

    Each shape is numbered such as Oval1, Oval2, Oval3, etc. In Column A are numbers that refer to the shapes. So if cell A11 contains the number “1”, it refers to the shape “Oval1”. If cell A13 contains the number “2”, it refers to the shape “Oval2”.

    In Column O of the same row is the cell that I am checking for the “X” that determines the color of the cell.

    While the numbers are consecutive, the rows are sometimes skipped. So Cell A13 may contain the value “2” (which refers to “Oval2” and I am checking Column O for the “X” in row 13). Cell A20 may contain the value 3 (which refers to “Oval3” and I am checking Column O for the “X” in row 20).

    Because it skips, I never know for sure what sheet contains the data for the specific shape. I need something that can check column O for the letter “X” and change the corresponding shapes color for each sheet. All the shapes are located on the sheet named "Print"

    Any help would be appreciated.

    Thanks
    Last edited by Hood; 10-08-2009 at 08:50 AM.

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