Offset activecell in linkedcell

[bak]

What is wrong in this macro?

With selection
.linkedcell = activecell.offset(0,3)
End with

 

[JackDanIce]

Can you post your whole code? Or at least some lines immediately before below?

 

[JamesW]

What are you trying to link? You can only use LinkedCell on controls.

 

[bak]

ActiveSheet.CheckBoxes.Add(192, 18, 47.25, 17.25).Select( this must be activecell)
With Selection
.Value = xlOff
.LinkedCell = activecell.offset(3,0)
.Display3DShading = False
End Sub

 

[JackDanIce]

I've just run your code and this is what I see happening.

It adds a checkbox around cell E3 and then selects the checkbox; because the checkbox is selected, no cells are.

You are then trying to link a cell (offset) to an activecell, but because you selected the checkbox, no cell is active so nothing can be linked

I think you need to explain in some more detail what you want or post an example of your sheet

 

[bak]

I want a checkbox in A2 linked to D2. When the activecell is A3 then the checkbox must be placed in A3 with the linkedcell D3