ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I resize the actual Forms checkbox (https://www.excelbanter.com/excel-discussion-misc-queries/79019-how-do-i-resize-actual-forms-checkbox.html)

Nel

How do I resize the actual Forms checkbox
 
I see many questions on how to create a checkbox, but resizing the the
checkbox itself seems to be my problem. Can't figure it out.

I notice there was another request for this problem but it went unanswered

hopefully I have better luck.

Ron de Bruin

How do I resize the actual Forms checkbox
 
Hi Nel

You can change the Top,Width,Left,Height

With Range("c3")
ActiveSheet.CheckBoxes.Add(Top:=.Top, Width:=.Width, _
Left:=.Left, Height:=.Height).Select
End With


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Nel" wrote in message ...
I see many questions on how to create a checkbox, but resizing the the
checkbox itself seems to be my problem. Can't figure it out.

I notice there was another request for this problem but it went unanswered

hopefully I have better luck.





All times are GMT +1. The time now is 04:07 AM.

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