Quick text to graphic converstion in excel

[CIOPMO]

Is it possible to take the text from a cell and turn it into a graphic?
ie: go = green circle
slow = yellow circle
stop = red circle
no info = white circle

I know you can manually replace the text, but I want to eliminate the
possibility for human error.

[mrice]

Have a look at the download workbook on my homepage which has a macro for creating graphics of this nature.

[Zygan]

try inserting this vba code into your editor

you will first need to create a image using the control tollbar and right click the image and set properties chnage name to green (or whatever) and the scroll down till you see picture and asign it a picture and test



Private Sub Worksheet_SelectionChange(ByVal Target As Range)
green.Visible = False
If ActiveCell = "go" Then
green.Visible = True
End If
End Sub

[CIOPMO]

I haven't used a lot of these before - can you give me more step by step
instructions?

"Zygan" wrote:

>
> try inserting this vba code into your editor
>
> you will first need to create a image using the control tollbar and
> right click the image and set properties chnage name to green (or
> whatever) and the scroll down till you see picture and asign it a
> picture and test
>
>
>
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> green.Visible = False
> If ActiveCell = "go" Then
> green.Visible = True
> End If
> End Sub
>
>
> --
> Zygan
> ------------------------------------------------------------------------
> Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
> View this thread: http://www.excelforum.com/showthread...hreadid=559406
>
>