Hi
I made a checkbox in cell B1, linked with the cell A1.
I want to make about 50 checkbox. when I use copy and paste or the fill
handler, I find that all the checkboxes are linked to the same cell A1 !!!!
BUT what I neeed to make checkbox in B1 linked to A1, and checkbox in B2
linked with A2, and checkbox in B3 linked with cell A3,....and so on.
Please HOW TO DO SO ?
Thanks Taha

Taha,

You could create them through code

Sub AddFormsCheckBoxes()
Dim i As Long
With ActiveSheet
For i = 1 To 50
.CheckBoxes.Add(Range("B" & i).Left, Range("B" & i).Top - 2,
126, 18).Select
With Selection
.Caption = "CB" & i
.Name = "CB" & i
.LinkedCell = "A" & i
End With
Next i
End With

End Sub


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Taha Elian" <Taha wrote in message
...
Hi
I made a checkbox in cell B1, linked with the cell A1.
I want to make about 50 checkbox. when I use copy and paste or the fill
handler, I find that all the checkboxes are linked to the same cell A1
!!!!
BUT what I neeed to make checkbox in B1 linked to A1, and checkbox in B2
linked with A2, and checkbox in B3 linked with cell A3,....and so on.
Please HOW TO DO SO ?
Thanks Taha