Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Check Box
Does anyone know of a way to convert a cell to a check box? We would like to
convert the cell rather than using the active X controls on top of it. Thanks. |
#2
|
|||
|
|||
You could double-click the cell and "convert" it to a=20
checkbox: Private Sub Worksheet_BeforeDoubleClick(ByVal Target _ As Range, Cancel As Boolean) With ActiveCell .Value =3D "=FC" .Font.Name =3D "Wingdings" .Borders(xlEdgeLeft).LineStyle =3D xlContinuous .Borders(xlEdgeTop).LineStyle =3D xlContinuous .Borders(xlEdgeBottom).LineStyle =3D xlContinuous .Borders(xlEdgeRight).LineStyle =3D xlContinuous .ColumnWidth =3D 2.57 End With End Sub --- To use, right-click on the sheet tab, go to View Code,=20 and paste in the code above. Press ALT+Q to exit. HTH Jason Atlanta, GA -----Original Message----- Does anyone know of a way to convert a cell to a check=20 box? We would like to=20 convert the cell rather than using the active X controls=20 on top of it. =20 Thanks. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
Auto spell check as in word | Excel Discussion (Misc queries) | |||
spell check protected document | Excel Discussion (Misc queries) | |||
Creating a check box that does not require security clearance. | Excel Worksheet Functions | |||
Why does spelling check close Excel when checking spanish? | Excel Discussion (Misc queries) |