Need help with pictures!
 

I do not know if this is possible, but if someone knows how to do it,
will be grateful.

So the problem is that i want to show a picture when a value i
negative, and another when is positive, can i do it?

Thanks!

--
RSise
-----------------------------------------------------------------------
RSisep's Profile: http://www.excelforum.com/member.php...fo&userid=3574
View this thread: http://www.excelforum.com/showthread.php?threadid=55522

Need help with pictures!
 

I would do it like this - Do it in two steps.
First:
You need to place some code in the worksheet or workbook excel object
to evaluate the cell you're looking at each time it calculates. Like
this:
Private Sub Worksheet_Calculate()
If Cells(1, "A") = "blue" Then
TogglePic "ON"
Else
TogglePic "OFF"
End If
End Sub

This will evaluate then toggle the pic on or off via the following
code:

Sub TogglePic(OnOff As String)
On Error Resume Next

If OnOff = "ON" Then Sheets("Sheet3").Shapes("Picture 1").Visible =
True
If OnOff = "OFF" Then Sheets("Sheet3").Shapes("Picture 1").Visible
= False

End Sub

Regards,
Jamie

RSisep wrote:
I do not know if this is possible, but if someone knows how to do it, i
will be grateful.

So the problem is that i want to show a picture when a value is
negative, and another when is positive, can i do it?

Thanks!!


--
RSisep
------------------------------------------------------------------------
RSisep's Profile: http://www.excelforum.com/member.php...o&userid=35741
View this thread: http://www.excelforum.com/showthread...hreadid=555223

Need help with pictures!
 

Thanks jseven!


--
RSisep
------------------------------------------------------------------------
RSisep's Profile: http://www.excelforum.com/member.php...o&userid=35741
View this thread: http://www.excelforum.com/showthread...hreadid=555223