B
Boss
I have 80 check box in a worksheet.
I wish to assign A1 to check box 1, A2 to check box 2.... so on and so forth.
I wrote a stupid code, please assit me with a correct one.
Sub Macro1()
For i = 1 To 5
ActiveSheet.Shapes("Check Box i").Select
With Selection
.Value = xlOff
.LinkedCell = "Ai"
.Display3DShading = False
End With
Next i
End Sub
Thanks a lot for ur help !!
Boss
I wish to assign A1 to check box 1, A2 to check box 2.... so on and so forth.
I wrote a stupid code, please assit me with a correct one.
Sub Macro1()
For i = 1 To 5
ActiveSheet.Shapes("Check Box i").Select
With Selection
.Value = xlOff
.LinkedCell = "Ai"
.Display3DShading = False
End With
Next i
End Sub
Thanks a lot for ur help !!
Boss