How to embedd "Harvey Ball" (symbol) in a cell
I would like to embedd a symbol into a cell. I dont want it to be done by using Fonts. By symbol I mean Harvey Balls (Plan, Do, Check, Act) symbol embedded the same as the "and" (&) symbol. I have seen it done once on a spreadsheet but did not get a copy and I would like to recreate it as a way of visually showing the status of an action item.
Thanks
Gezza
Last edited by Gezza; 06-21-2009 at 08:42 PM.
Did you see the response I posted in your last thread on the exact same topic?
Why not use a font?
Last edited by shg; 06-11-2009 at 07:04 PM.
Entia non sunt multiplicanda sine necessitate
Hi Shg,
Arh, good question
I am using it in a Data Validation List so if I use Fonts I dont get the Harvey symbol in the drop down list.
Also I can see other possible uses, and it bugs me to know that it can be done but I don't how!
I don't think you're going to see symbols in a data validation drop-down under any circumstances.
You could do it (sort of) with a ListBox from the Control Toolbox.
Last edited by shg; 06-11-2009 at 08:00 PM.
Hi shg,
Thanks for your help so far
I've attached an example where it has been done, but you will notice that the symbols are different sizes. But it is working in the validation?
You've made your point very well -- but I don't know how to duplicate it, sorry.
Someone else here will.
It does use a Harvey Balls font, though.
You might find this helpful -
http://http://www.tushar-mehta.com/p...rvey_Balls.htm
Thanks Bigmack,
I have seen these solutions before but none of them work they way I want in data validation lists
Thanks again
Gezza
The only way I could duplicate the list was to use VBA to generate the Unicode strings!
Here is a sheet I created from scratch using a small UDF to generate the UNICODE characters!
Then just use validation list referencing the cells as normal!
Last edited by squiggler47; 06-12-2009 at 03:55 AM. Reason: uPDATED TO INCLUDE ALL HARVEY BALLS
Regards
Darren
Update 12-Nov-2010 Still job hunting!
If you are happy with the results, please add to our reputation by clicking the blue scales icon in the blue bar of the post.
Learn something new each day, Embrace change do not fear it, evolve and do not become extinct!
Thanks squiggler47
I think you have done it. At least I know that it is created by "UnicodeChar".
But can I create my own UnicodeChar?
Some of the Havey Balls are different in size and I need them to be larger, I've tried increasing font size but then the size difference become obvious.
However you have helped me a lot. thanks again
I will continue to explore other unicodeChar symbols now I know how
Gezza
I took the codes from your original set and also combined the ones on wikkipedia under harveyballs!Originally Posted by Gezza
The unicode characters are fixed, but using the ones on wikipedia they should be a matched set, the circle/cross one isnt part of the set which is why it appears different!
fyi it doesnt work at all in excel 97
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Although I now have found a way of doing what I set out to do, I am not necessarily happy with the results, because the Harvey Balls symbols are not a matching set (some are different in size).
This makes the speadsheet look a little unprofessional.
I have now explored many unicode symbols, and there are thousands, some quite intricate, try typing this in a excel spreadsheet =UnicodeChar(9731) or (1160).
These are created somewhere? I'd like to know how
I'm going to try using pie charts
Last edited by Gezza; 06-12-2009 at 08:39 PM. Reason: I've found the answer through wikipedia, but still have a problem
They are defined by the Unicode ConsortiumThese are created somewhere? I'd like to know how.
The results may vary depending on the font you use as well!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks