Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simulate Check Box
Using Excel 2003 - Is there any other way to simulate a check box in a cell?
I have a form that I want users to be able to check a box for a certain request. I cannot use the check box because when I print it, it's too small. Is there any other method to use? Thanks to everyone who has helped me on this message board. Everyone is ALWAYS so helpful. Karen |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simulate Check Box
hi
format the cell to font Marlett then enter a lower case a or lower case b. this will but a check mark in the cell and the font size and be increased or decreased to suit. regards FSt1 "Karen" wrote: Using Excel 2003 - Is there any other way to simulate a check box in a cell? I have a form that I want users to be able to check a box for a certain request. I cannot use the check box because when I print it, it's too small. Is there any other method to use? Thanks to everyone who has helped me on this message board. Everyone is ALWAYS so helpful. Karen |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simulate Check Box
Thanks! That is a cool trick! I will definitely use that for future.
Although, several people will use this form and users would get confused (I'm guessing) if I tell them to enter a lowercase b. Any other suggestions? Thanks, Karen "FSt1" wrote: hi format the cell to font Marlett then enter a lower case a or lower case b. this will but a check mark in the cell and the font size and be increased or decreased to suit. regards FSt1 "Karen" wrote: Using Excel 2003 - Is there any other way to simulate a check box in a cell? I have a form that I want users to be able to check a box for a certain request. I cannot use the check box because when I print it, it's too small. Is there any other method to use? Thanks to everyone who has helped me on this message board. Everyone is ALWAYS so helpful. Karen |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simulate Check Box
Why not use Data Validation so that only 'b' is allowed?
They still may enter 'B' but the data validation list should remind them a 'b' is needed best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Karen" wrote in message ... Thanks! That is a cool trick! I will definitely use that for future. Although, several people will use this form and users would get confused (I'm guessing) if I tell them to enter a lowercase b. Any other suggestions? Thanks, Karen "FSt1" wrote: hi format the cell to font Marlett then enter a lower case a or lower case b. this will but a check mark in the cell and the font size and be increased or decreased to suit. regards FSt1 "Karen" wrote: Using Excel 2003 - Is there any other way to simulate a check box in a cell? I have a form that I want users to be able to check a box for a certain request. I cannot use the check box because when I print it, it's too small. Is there any other method to use? Thanks to everyone who has helped me on this message board. Everyone is ALWAYS so helpful. Karen |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simulate Check Box
Hi Karen
You could use some event code - like double click. The following code is based upon column D, change the column number to suit your requirement. On double click, the code checks to see if the cell is empty. If it is, it formats the cell to Marlett and inserts an "a" If the cell already contains a character, it deletes it and sets the font back to Arial. Either change the font to your standard, or remove the line altogether if you are happy for the font to remain as Marlett. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target.Column < 4 Then Exit Sub ' choose column Number If Target.Count 1 Then Exit Sub If Target.Value = "" Then Target.Font.Name = "Marlett" Target = "a" Else Target.Font.Name = "Arial" ' set to your normal default font Target = "" End If End Sub Copy the Code above Right click Sheet tab View Code Paste code into white pane that appears Alt+F11 to return to Excel -- Regards Roger Govier "Karen" wrote in message ... Thanks! That is a cool trick! I will definitely use that for future. Although, several people will use this form and users would get confused (I'm guessing) if I tell them to enter a lowercase b. Any other suggestions? Thanks, Karen "FSt1" wrote: hi format the cell to font Marlett then enter a lower case a or lower case b. this will but a check mark in the cell and the font size and be increased or decreased to suit. regards FSt1 "Karen" wrote: Using Excel 2003 - Is there any other way to simulate a check box in a cell? I have a form that I want users to be able to check a box for a certain request. I cannot use the check box because when I print it, it's too small. Is there any other method to use? Thanks to everyone who has helped me on this message board. Everyone is ALWAYS so helpful. Karen |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simulate Check Box
(saved from a previous post)
Select the range that would have held the checkboxes. 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 (make it as large as you want) 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") or =counta(a1:a10) to get the number of "checked" cells in A1:A10 Or you can filter by blanks and non-blanks. Karen wrote: Using Excel 2003 - Is there any other way to simulate a check box in a cell? I have a form that I want users to be able to check a box for a certain request. I cannot use the check box because when I print it, it's too small. Is there any other method to use? Thanks to everyone who has helped me on this message board. Everyone is ALWAYS so helpful. Karen -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simulate Check Box
CHAR(252) in the wingdings font is a Tick
CHAR(251) is a cross set the size to what ever you need You could use data validation to create a list - the only challenge is that in the list they both appear to be "ü" edvwvw Karen wrote: Using Excel 2003 - Is there any other way to simulate a check box in a cell? I have a form that I want users to be able to check a box for a certain request. I cannot use the check box because when I print it, it's too small. Is there any other method to use? Thanks to everyone who has helped me on this message board. Everyone is ALWAYS so helpful. Karen -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200904/1 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simulate Check Box
CHAR(252) in the wingdings font is a Tick
CHAR(251) is a cross set the size to what ever you need You could use data validation to create a list - the only challenge is that in the list they both appear to be "ü" edvwvw Karen wrote: Using Excel 2003 - Is there any other way to simulate a check box in a cell? I have a form that I want users to be able to check a box for a certain request. I cannot use the check box because when I print it, it's too small. Is there any other method to use? Thanks to everyone who has helped me on this message board. Everyone is ALWAYS so helpful. Karen -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200904/1 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simulate Check Box
VERY cool - Thanks!
"Dave Peterson" wrote: (saved from a previous post) Select the range that would have held the checkboxes. 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 (make it as large as you want) 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") or =counta(a1:a10) to get the number of "checked" cells in A1:A10 Or you can filter by blanks and non-blanks. Karen wrote: Using Excel 2003 - Is there any other way to simulate a check box in a cell? I have a form that I want users to be able to check a box for a certain request. I cannot use the check box because when I print it, it's too small. Is there any other method to use? Thanks to everyone who has helped me on this message board. Everyone is ALWAYS so helpful. Karen -- Dave Peterson |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simulate Check Box
Thank you so much for your help!
Karen "Bernard Liengme" wrote: Why not use Data Validation so that only 'b' is allowed? They still may enter 'B' but the data validation list should remind them a 'b' is needed best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Karen" wrote in message ... Thanks! That is a cool trick! I will definitely use that for future. Although, several people will use this form and users would get confused (I'm guessing) if I tell them to enter a lowercase b. Any other suggestions? Thanks, Karen "FSt1" wrote: hi format the cell to font Marlett then enter a lower case a or lower case b. this will but a check mark in the cell and the font size and be increased or decreased to suit. regards FSt1 "Karen" wrote: Using Excel 2003 - Is there any other way to simulate a check box in a cell? I have a form that I want users to be able to check a box for a certain request. I cannot use the check box because when I print it, it's too small. Is there any other method to use? Thanks to everyone who has helped me on this message board. Everyone is ALWAYS so helpful. Karen |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simulate Check Box
Thank you so much for your help!
Karen "FSt1" wrote: hi format the cell to font Marlett then enter a lower case a or lower case b. this will but a check mark in the cell and the font size and be increased or decreased to suit. regards FSt1 "Karen" wrote: Using Excel 2003 - Is there any other way to simulate a check box in a cell? I have a form that I want users to be able to check a box for a certain request. I cannot use the check box because when I print it, it's too small. Is there any other method to use? Thanks to everyone who has helped me on this message board. Everyone is ALWAYS so helpful. Karen |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simulate Check Box
Thank you so much for your help!
Karen "Roger Govier" wrote: Hi Karen You could use some event code - like double click. The following code is based upon column D, change the column number to suit your requirement. On double click, the code checks to see if the cell is empty. If it is, it formats the cell to Marlett and inserts an "a" If the cell already contains a character, it deletes it and sets the font back to Arial. Either change the font to your standard, or remove the line altogether if you are happy for the font to remain as Marlett. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target.Column < 4 Then Exit Sub ' choose column Number If Target.Count 1 Then Exit Sub If Target.Value = "" Then Target.Font.Name = "Marlett" Target = "a" Else Target.Font.Name = "Arial" ' set to your normal default font Target = "" End If End Sub Copy the Code above Right click Sheet tab View Code Paste code into white pane that appears Alt+F11 to return to Excel -- Regards Roger Govier "Karen" wrote in message ... Thanks! That is a cool trick! I will definitely use that for future. Although, several people will use this form and users would get confused (I'm guessing) if I tell them to enter a lowercase b. Any other suggestions? Thanks, Karen "FSt1" wrote: hi format the cell to font Marlett then enter a lower case a or lower case b. this will but a check mark in the cell and the font size and be increased or decreased to suit. regards FSt1 "Karen" wrote: Using Excel 2003 - Is there any other way to simulate a check box in a cell? I have a form that I want users to be able to check a box for a certain request. I cannot use the check box because when I print it, it's too small. Is there any other method to use? Thanks to everyone who has helped me on this message board. Everyone is ALWAYS so helpful. Karen |
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simulate Check Box
Thank you so much for your help!
Karen "edvwvw via OfficeKB.com" wrote: CHAR(252) in the wingdings font is a Tick CHAR(251) is a cross set the size to what ever you need You could use data validation to create a list - the only challenge is that in the list they both appear to be "ü" edvwvw Karen wrote: Using Excel 2003 - Is there any other way to simulate a check box in a cell? I have a form that I want users to be able to check a box for a certain request. I cannot use the check box because when I print it, it's too small. Is there any other method to use? Thanks to everyone who has helped me on this message board. Everyone is ALWAYS so helpful. Karen -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200904/1 |
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simulate Check Box
Thank you so much for your help!
Karen "edvwvw via OfficeKB.com" wrote: CHAR(252) in the wingdings font is a Tick CHAR(251) is a cross set the size to what ever you need You could use data validation to create a list - the only challenge is that in the list they both appear to be "ü" edvwvw Karen wrote: Using Excel 2003 - Is there any other way to simulate a check box in a cell? I have a form that I want users to be able to check a box for a certain request. I cannot use the check box because when I print it, it's too small. Is there any other method to use? Thanks to everyone who has helped me on this message board. Everyone is ALWAYS so helpful. Karen -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200904/1 |
#15
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simulate Check Box
Just curious - Why do you have to type alt-0252 multiple times? It works,
just wondering why. Karen "Dave Peterson" wrote: (saved from a previous post) Select the range that would have held the checkboxes. 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 (make it as large as you want) 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") or =counta(a1:a10) to get the number of "checked" cells in A1:A10 Or you can filter by blanks and non-blanks. Karen wrote: Using Excel 2003 - Is there any other way to simulate a check box in a cell? I have a form that I want users to be able to check a box for a certain request. I cannot use the check box because when I print it, it's too small. Is there any other method to use? Thanks to everyone who has helped me on this message board. Everyone is ALWAYS so helpful. Karen -- Dave Peterson |
#16
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simulate Check Box
The number format string consists of 4 parts separated by a semicolon:
Positive;Negatives;Zero;Text I would expect that you want to see that checkmark no matter what's typed. Karen wrote: Just curious - Why do you have to type alt-0252 multiple times? It works, just wondering why. Karen "Dave Peterson" wrote: (saved from a previous post) Select the range that would have held the checkboxes. 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 (make it as large as you want) 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") or =counta(a1:a10) to get the number of "checked" cells in A1:A10 Or you can filter by blanks and non-blanks. Karen wrote: Using Excel 2003 - Is there any other way to simulate a check box in a cell? I have a form that I want users to be able to check a box for a certain request. I cannot use the check box because when I print it, it's too small. Is there any other method to use? Thanks to everyone who has helped me on this message board. Everyone is ALWAYS so helpful. Karen -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
simulate values for a given Mean and Standard deviation | Excel Discussion (Misc queries) | |||
Trying to simulate 2 separate users in connection with a Share Wor | Excel Discussion (Misc queries) | |||
Trying to simulate 2 separate users in connection with a Share Wor | Excel Discussion (Misc queries) | |||
how do i simulate a king queen or jack playing card in excel assum | Excel Discussion (Misc queries) |