Trying to scale a form checkbox in a macro, don't know how to get checkbox name

**tstruch** · 01-07-2014, 11:17 PM

First off, let me apologize because I'm a complete newbie when it comes to programming in Excel.

I'm trying to insert a row that includes a checkbox (centered in the cell) that has it's linked cell adjacent to it. I've been able to cobble together the code to make this happen. The problem I'm having is that the height of the newly created checkbox is larger than that of the row, so that when the macro is called again, it distorts the checkbox above. Below is the code that I have so far:

Please Login or Register  to view this content.

I've attempted to modify the top and height, but I can't get a satisfactory result. Any help in trying to get the checkbox to fit within the row height?

Please let me know if you need any further info and I'll try to answer to the best of my ability.

Thanks.

**coolblue** · 01-08-2014, 01:43 AM

You just need to experiment and take a logical approach.
By doing that you can figure out that the check box is offset by 3.5 and the box is 9.5 x 9.5
So you subtract 3.5 to align it with the left edge of the cell, then ad 9.5/2 to align the center of the check box with the left edge of the cell, then offset it by half the cell width.

For the height, you can just record a macro while you adjust it and you will find that the property you need is scaleheight

Please Login or Register  to view this content.

Or you can make yourself a tool like this

Please Login or Register  to view this content.

Then put a number to the left to be the Top offset and a number to the right to be the left offset...
checkbox.jpg

... and experiment
Then when you have something close, find the best compromise
final checkbox.jpg

Then after a little bit of fine tuning

Please Login or Register  to view this content.

is your best compromise.

**tstruch** · 01-08-2014, 10:44 AM

Thanks so much for your help!

**coolblue** · 01-09-2014, 12:14 AM

Hi, did it solve your problem?
Did you try the tool to see how to do it for yourself?

Trying to scale a form checkbox in a macro, don't know how to get checkbox name

LinkBack

Thread Tools

Rate This Thread

Display

Trying to scale a form checkbox in a macro, don't know how to get checkbox name

Re: Trying to scale a form checkbox in a macro, don't know how to get checkbox name

Re: Trying to scale a form checkbox in a macro, don't know how to get checkbox name

Re: Trying to scale a form checkbox in a macro, don't know how to get checkbox name

Thread Information

Users Browsing this Thread

Similar Threads

Form Control Checkbox to checkmark other Form Control Checkbox/s

[SOLVED] How do I change a checkbox to unchecked without running the code within the checkbox

[SOLVED] Use excel form Checkbox and tweak macro to suit.

[SOLVED] Macro for creating checkbox in the Form

checkbox on form reset from checkbox on sheet

Bookmarks

Bookmarks

Posting Permissions