![]() |
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! |
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