OLEObject Update LinkedCell witch VBA Code for a Check-Box

[PZiegler12]

Hi,

I have this code which creates an ActiveX Check-Box with vba:

With .OLEObjects.Add(ClassType:="Forms.CheckBox.1", Link:=False, DisplayAsIcon:=False, _
         Left:=30, _
         Top:=30, _
         Width:=20, _
         Height:=5)
     .Name = "check_Sb_"
     .Object.Caption = "checkbox Sb"
     .Object.Value = False
     .LinkedCell = Cells(10, 13).Address(0, 0)
     .Enabled = True
End With

So far. Now how can I update the LinkedCell immidiately after I created the CheckBox?
Is there a OLEObject-Method? The Value which is updated can be "WAHR" oder "FALSCH"
which is written to the LinkedCell.

Thanks for Answers

 

[PZiegler12]

I found out a workaround of this issue. I symply write into the LinkedCell after it is referenced the "WAHR" oder "FALSCH" value and the
checkbox changed automatically.