Check Box

D

d

I am trying to add check boxes to a protected document
that will be selected when I tab through the document.
Does anyone know if the check boxes can be formatted to be
activated in theis way. Right now, I have to select the
check boxes with the mouse.

Thanks
 
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. Add this code to the worksheet module
(right-click on the sheet name tab, select the View option, and then paste
this code in).

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
 
Top