Need help with Check Boxes and Linking Cells

[myorkovi]

I need to insert a check box into an excel worksheet. I need to be able to "check" or "uncheck" the box. Here's the tricky part. If I select "check", i need to have the data 4 cells immediately to the left of the checked box automatically copied into cells on another worksheet in the workbook.

I am having sales forecasts turned in to me and I need to be able to check the box to have only those accounts that are going to close, copied into the other sheet.

Also, when I insert a checkbox, the actual box itself is very small, can it be resized? I can change the text but not the little box itself.

Thanks for your help!!!

 

[Lball]

Someone here gave me this code to have column A have a checkbox. If you click once a check appear, double click and it disappears. This will get you started.

I right clicked on the page tab that i wanted this code and chose "View code" Then pasted. It worked from there.

Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Count > 1 Then Exit Sub
    If Target.Column <> 1 Then Exit Sub
    If Target.Row > Range("B65536").End(xlUp).Row Then Exit Sub
    If IsEmpty(Target) Then
        Target.Formula = "=CHAR(252)"
        Target.Value = Target.Value
        With Target.Font
            .Name = "Wingdings"
            .FontStyle = "Bold"
            .Size = 8
        End With
        Target.Borders.LineStyle = xlContinuous
    Else
        Target.ClearContents
    End If
End Sub

 

[myorkovi]

Thanks..I will give it a try.