Thread: Inserting Multiple Check boxes

Is there a way to a mass insert of Check Boxes without the cell link all being the same cell?

I have a huge list of items that I want to put a check box next to each one. This way when my warehouse people check it off in the sheet one of the columns will read "Available".

Problem is when I put the first box in and cell link it to E4, and then copy and paste it, all the boxes toggle based on one another.

Otherwise I have to put in 584 check boxes

Solutions or other recommendations are gladly welcome.

Also, is "True/False" the only available "response" when using Check boxes? (I Know I can write an equation based on the true false, but I am just curious)

There's a great macro here for this:

http://blog.livedoor.jp/andrewe/archives/17357484.html

Just select a range of cells and run the macro, it inserts a checkbox in every cell and links the box to the cell underneath...it even adds a nice conditional formatting so that when you check the box the cell changes color.

That should get you started.

Rather than inserting and maintaining checkboxes, you could make cells act like checkboxes. As an example,putting this in the code module for a sheet, then B1:B10 will act like check boxes (contain TRUE or FALSE and clicking on the cell will change the value).

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    With Target
        If (Not Application.Intersect(.Cells, Range("B1:B10")) Is Nothing) _
                And (.Cells.Count = 1) Then
            Application.EnableEvents = False
            .Value = Not (CStr(Target.Value) = "True")
            .Offset(0, 1).Select
            Application.EnableEvents = True
        End If
    End With
End Sub

The hard-coded "B1:B10" can be altered to meet your situation.

AND, True/False are the only possible return values from an ActiveX check box. (Forms text boxes have an underlying value of xlOn/xlOff that shows in the linked cell as TRUE/FALSE). Those are the only two options.