ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Resizing Checkbox (https://www.excelbanter.com/excel-programming/395573-resizing-checkbox.html)

Magnivy

Resizing Checkbox
 
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!

Jim Cone

Resizing Checkbox
 

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!


All times are GMT +1. The time now is 10:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com