Quick text to graphic converstion in excel
 

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.

Quick text to graphic converstion in excel
 

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


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=559406

Quick text to graphic converstion in excel
 

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

Quick text to graphic converstion in excel
 

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