Quick text to graphic converstion in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Have a look at the download workbook on my homepage which has a macro
for creating graphics of this nature.
 
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
 
Back
Top