Resizing Checkbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a macro that inserts checkboxes to every cell in a range. My macro
uses the following code to add the checkboxes:

..Parent.CheckBoxes.Add (Top:=.Top, Width:=.Width, Left:=.Left,
Height:=.Height)

When I tried changing the parameters for Top, Width, Left, and Height, only
the boxes surrounding the checkboxes changed, not the checkboxes themselves.
Is there a way to increase the size of the checkboxes?

Thank you very much for your help!
 
Not that I know of.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Magnivy"
wrote in message
Hello,
I have a macro that inserts checkboxes to every cell in a range. My macro
uses the following code to add the checkboxes:

..Parent.CheckBoxes.Add (Top:=.Top, Width:=.Width, Left:=.Left,
Height:=.Height)

When I tried changing the parameters for Top, Width, Left, and Height, only
the boxes surrounding the checkboxes changed, not the checkboxes themselves.
Is there a way to increase the size of the checkboxes?
Thank you very much for your help!
 
Back
Top