I am trying to insert an ActiveX Checkbox into a worksheet. Have finally figured out many things on how to do this, however am stumped on getting the “Linked Cell” to work without a “Run-time error ‘438’: Object doesn’t support this property or method” The code between the asterisks:
“.LinkedCell = LC.Address”
seems to cause the error. I have tried many other versions from websites all over:
'.LinkedCell = Cells(r + 1, 26).Address
'.Placement = xlMove
'.LinkedCell = LC.Offset(0, -8).Address
'.LinkedCell = LC.Address
'.LinkedCell = .TopLeftCell.Offset(0, lCol).Address
'.LinkedCell = Cells(r + 1, 26).Address
'.LinkedCell = ActiveSheet.Range("Z" & (r + 1))
None seem to work.
I would appreciate any help anyone could give me. Would also like to change the name to "Checkbox_" & (r+1), if that is possible, however I get a similar error if I try to use .Name:="Checkbox_" & (r+1)
Current Code is:
Thanks in advance,
Papa Newch
Bookmarks