Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check Mark appears when a letter is entered in a field
What do I need to do to create a field which displays a check mark when a
letter is entered into the field? I saw this on a template for project management. Thanks Gina |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check Mark appears when a letter is entered in a field
Maybe...
Select the range Format|cells|number tab|custom category In the "type:" box, put this: alt-0252;alt-0252;alt-0252;alt-0252 But hit and hold the alt key while you're typing the 0252 from the numeric keypad. It should look something like this when you're done. ü;ü;ü;ü (umlaut over the lower case u separated by semicolons) And format that range of cells as Wingdings. Now, no matter what you type (spacebar, x, anyoldtextatall), you'll see a check mark. Hit the delete key on the keyboard to clear the cell. If you have to use that "checkmark" in later formulas: =if(a1="","no checkmark","Yes checkmark") Gina wrote: What do I need to do to create a field which displays a check mark when a letter is entered into the field? I saw this on a template for project management. Thanks Gina -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check Mark appears when a letter is entered in a field
Any letter or a particular letter?
Any cell or a particular cell? Without programming................ Format a cell to Marlett font and enter the letter "a" to get a checkmark. On Thu, 22 Feb 2007 11:38:21 -0800, Gina wrote: What do I need to do to create a field which displays a check mark when a letter is entered into the field? I saw this on a template for project management. Thanks Gina |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I add active tick mark/check mark boxes in excel? | Excel Discussion (Misc queries) | |||
Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
How do I get a field in excel to auto complete with a check mark | Excel Discussion (Misc queries) | |||
check box, so when you click on it it inserts a check mark into t. | Excel Discussion (Misc queries) | |||
Excel: How do I type a letter in a column and make a check mark a. | Excel Worksheet Functions |