M mcl Aug 23, 2008 #1 Is it possible, with Excel 2007 to select a graphic/picture based on a condition?
A AltaEgo Aug 24, 2008 #2 mcl said: Is it possible, with Excel 2007 to select a graphic/picture based on a condition? Click to expand... Sub Macro1() ' ' If Cells(1, 1).Value > 1 Then ActiveSheet.Shapes("Rectangle 3").Select Else ActiveSheet.Shapes("Oval 4").Select End If End Sub
mcl said: Is it possible, with Excel 2007 to select a graphic/picture based on a condition? Click to expand... Sub Macro1() ' ' If Cells(1, 1).Value > 1 Then ActiveSheet.Shapes("Rectangle 3").Select Else ActiveSheet.Shapes("Oval 4").Select End If End Sub
