Custom checkbox

  • Thread starter Thread starter Hank Hendrix
  • Start date Start date
H

Hank Hendrix

I have a large (10 page) worksheet that is mostly cells to select YES, NO,
N/A, SAT, UNSAT.

How can I:
1. Resize the built in excel checkbox or radio buttons?
or
2. Have an "X" or large custom check mark placed in the correct cell with a
mouse click?
or
3. Another way to simply filling out this sheet?

I have Excel97, VBA, and Excel 2000.
Thanks
Hank
 
1 - You can't change the size of these objects.
2 - You can use the Worksheet_SelectionChange event to
place an X in a cell.
3 - see # 2

Private Sub Worksheet_SelectionChange(ByVal Target As
Range)

'Assume you want only one cell from A1 to A5 to be X'd at
any time. This will ensure only the cells you want to
deal with are handled here, and place an X in the selected
cell.
If Target.Column = 1 And Target.Row <= 5 And
Target.Cells.Count = 1 Then
'Clear all 5 cells, then set just the one cell to X
Range("A1:A5").Value = ""
Target.Value = "X"
End If

End Sub
 
Back
Top