is it possible to insert chcekboxes in an excel spreadsheet?

A

analiese f

I am trying to track the status of jobs using an excel spreadsheet, and I'm
looking for an easy way to select between several options I've placed in the
spreadsheet. It would be great if I can use checkboxes so that users can
highlight as many options as relevant, but I'm not sure if this is possible.
Does anyone know how to do this? And if not can anyone offer another
solution??
Thanks
 
C

Carole O

Check out the Forms toolbar - there is a check box in that. (View, toolbar,
forms)

Hope this helps,
Carole
 
B

Bob Phillips

you could try this solution that I came up with a while back. This is a copy
of that post


Another way is to use this technique of having a check column, and
monitoring it with a worksheet selection change event. Add your code as
needed.


Rather than use a checkbox, I suggest just using a check column. So if we
assume that the data is in A1:E100 (change to suit), clicking in column A
will do what you want with this code.


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.EnableEvents = False
On Error GoTo sub_exit
If Not Intersect(Target, Range("A1:A100")) Is Nothing Then
With Target
If .Value = "a" Then
.Value = ""
Else
.Value = "a"
.Font.Name = "Marlett"
End If
End With
End If
sub_exit:
Application.EnableEvents = True
End Sub


'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.



--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top