Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
moving text from a word document to excel | New Users to Excel | |||
Error message when using Excel to open text file | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel - merged cells w/wrapped text auto row height doesn't work. | Excel Discussion (Misc queries) | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) |