Office 2010: Office 2010: CheckBox Makro Zellbezug ändern [erledigt]

[Feldmann]

Habs, den Code lass ich mal stehen, vielleicht hilft er irgend wem mal ^^

Der Code:

Code: [Auswählen]

Option Explicit

Sub CheckBox()
    Dim Repeat As Integer
    Dim Position As Double
        Application.ScreenUpdating = False
        Position = 25
        ActiveSheet.Range("V:V").Font.ColorIndex = 2
For Repeat = 2 To 5
    With ActiveSheet.CheckBoxes.Add(1119, Position, 16, 16)
        .LinkedCell = "$V$" & Repeat
        .Characters.Text = ""
    End With
Position = Position + 12.75
Next
End Sub
Danke soweit