Checkbox Cell Link

angleyez423

New Member
Joined
Dec 3, 2005
Messages
5
Is there an easier way to format the link cell when using a check box in the forms toolbox. I have been...

Right clicking...Format Control...Control...Cell Link

The problem is that I have hundreds of boxes and this is a pain.

Thank you!
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

tactps

Well-known Member
Joined
Jan 20, 2004
Messages
3,459
If there is a logic to it, you could create a macro:

Sub Macro1()
Dim counter As Integer
counter = 1
Do Until counter = 100
ActiveSheet.Shapes("Check Box " & counter).Select
With Selection
.LinkedCell = "$B$" & counter
End With
counter = counter + 1
Loop
End Sub

This will link Check Box 1 to cell B1, Box 2 to B2, etc.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,144
Messages
5,576,326
Members
412,716
Latest member
thviid
Top