Checkboxes in Excel...

[tigger23]

Hi,I am making a spreadsheet and want to use the checkbox control. The sheet is to be sent to people, they then click the checkbox next to certain items on the sheet and return it. Once return the data needs to be analaysed, the checkbox column will be copied intoa master sheet, and the total number of checkboxes with ticks for each row needs to be calculated. I have tried using a control checkbox (but havent worked out what code to put behind it), and also a form checkbox, but i can't seem to work out the technical bit! PLEASE HELP ME!!cheers
tigger

 

[SkipVought]

Hi,
Are you using Forms or Control Toolbox? Skip,
metzgsk@voughtaircraft.com

 

[LSTAN]

Hi

If you are using the Control checkbox, you might want to try to link the CheckBox_Click() event to a particular cell in the worksheet.

Hope this will help

LSTAN

 

[SkipVought]

When you configure you CheckBox, (from Tool Box) set the Tag property to "Checkbox".

Then when you get back the workbook, run this code...

    Dim Boxes(), i
    i = 0
    For Each Shape In Shapes
        With Shape.DrawingObject.Object
            Select Case .DisplayStyle
                Case fmDisplayStyleCheckBox
                    If .Value Then
                        i = i + 1
                        ReDim Preserve Boxes(1 To i)
                        Boxes(i) = Shape.Name
                    End If
            End Select
        End With
    Next
    For i = 1 To UBound(Boxes, 1)
        MsgBox Boxes(i)
    Next

The for...next at the bottom just shows you what was selected.

Hope this helps
Skip,
metzgsk@voughtaircraft.com