View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Adam Kroger
 
Posts: n/a
Default Checkbox question

can you "lock" a checkbox to its linked cell in regards to height, width,
and position?

In other words once placed, the checkbox would cover the cell, and if the
size or position of the cell is changed the size/position of the box would
alter with it.

if so:

what is the setting?

how would this need to be noted in VBA?
For Each rCell In rng
With SH.CheckBoxes.Add(rCell.Left + 4, _
rCell.Top - 2, 0, 0)
.Caption = ""
.LinkedCell = rCell.Address(0, 0)
End With