If/Condition Applied to Pictures?

  • Thread starter Thread starter mcl
  • Start date Start date
M

mcl

Is it possible, with Excel 2007 to select a graphic/picture based on a
condition?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting based on dynamic Date 1
Help needed 0
CONDITIONAL FORMATTING BETWEEN SHEETS 1
Multiple Condition Formatting 3
Conditional Formatting 2
Conditional Formatting on Multiple Worksheets 1
Copy Conditional Formatting to Another Sheet 3
Conditional Formatting 1

Back
Top