Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert True/False to checkboxes
Can I convert True/False text to checkboxes within Excel
using VBA? If so, how? I tried using the help feature and nothing comes up. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert True/False to checkboxes
Hi Eric:
You can't *convert* text to checkboxes. You can place checkboxes (from the Forms Toolbar or the Control Toolbox) on your worksheet and link them to the cells containing the TRUE/FALSE (Boolean, not text) values. Regards, Vasant. "Eric" wrote in message ... Can I convert True/False text to checkboxes within Excel using VBA? If so, how? I tried using the help feature and nothing comes up. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert True/False to checkboxes
Hi,
It may not be what you want, but you could try this: Put this code in the module of the sheet that will have the check and in this example, if you double-click in a cell in the "D" column , you will see appear or disappear a check mark. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target.Value = Chr(252) Then Target.Value = "" Exit Sub End If If Target.Column = 4 And Target.Value = "" Then Target.Font.Name = "Wingdings" Target.Value = Chr(252) End If End Sub -- JP http://www.solutionsvba.com "Eric" wrote in message ... Can I convert True/False text to checkboxes within Excel using VBA? If so, how? I tried using the help feature and nothing comes up. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Discussion (Misc queries) | |||
convert Boolean true-false to zero's and ones | Excel Discussion (Misc queries) | |||
TRUE/FALSE from checkboxes | Excel Discussion (Misc queries) | |||
How can you convert the false/true into 1/0 in Excel? | Excel Worksheet Functions | |||
Convert TRUE/FALSE results to a number | Excel Worksheet Functions |