Center Checkbox
Hi,
Try something like:
Dim cell as Range
Dim chk as Excel.Checkbox
Set cell=activecell
Set chk = wsh.CheckBoxes.Add(cell.Left + 0.3 * cell.Width, cell.Top,
cell.Width, cell.Height)
chk.Height = cell.Height - 1.5
--
Regards,
Sébastien
<http://www.ondemandanalysis.com
<http://www.ready-reports.com
"ranswert" wrote:
How do I write a procedure that centers a checkcox vertically in a cell?
|