Checkbox Macro

Question

Can someone provide me with the VBA macro code for a simple 'checkbox' to use in Excel 2010...

Answer 1

Keith,

Thank you, I am familiar with the ability to increase the size of the font.  As for having to 'enable VBA', this form will be used by only one person, so not an issue.

Can anyone else help me with what I'm trying to accomplish?

Thank you Keith, and to anyone who might be willing to assist me.

Randy

Answer 2

If you want to increase the size of the (forms) checkbox itself, then I don't know how to do that. If you just want to increase the size of the accompanying text, you can create checkboxes with larger text by modifying Isabelle's code found here: http://social.msdn.microsoft.com/Forums/en-US/isvvba/thread/fdc94a91-71c8-42c1-ba92-9261a431fe10/

If you decide to pursue the VBA route (which is fine), just remember that it will require your users to enable VBA in order to use the checkboxes.

Perhaps another forum member will have already done what you are looking for, and share their code.

Answer 3

Keith, thank you for your reply.

I am presently using the 'Developer/Insert/FormControl/Checkbox' on an excel form (template) that has a list of line items that might apply in a given situation, in this case, a Project Information Sheet, showing what applies, what doesn't apply.  I do not need to trigger anything, or compile information, I simply need to have a toggle button that will display an 'X' with one mouse click, and remove the 'X' with a second mouse click.

My only issue with the checkbox (mentioned above) is that I cannot increase the size of the checkbox.  Therefore, my thought is that I'd like to use 'Insert/Shape/Square' and create a 'Standard Module' and create a 'Checkbox' in that manner, and in need of the VBA Macro Code to make this all happen...am I making sense.

On a side note, if you know a better, more effecient way to achieve the same thing, I'd be greatful for your input.

thanks,

randy

Answer 4

What type of macro?

You can link a checkbox directly to a cell, so that you can access the checkbox state in other formulas.

Or do you want to trigger something specific to happen when a checkbox is checked?

Or, is your checkbox on a userform?

Are you using a form control (preferred) or an activeX control?

To answer the easiest possible scenario- right click on your form control and select format control. Go to the 'control' tab, and in the cell link box, enter a cell address. From then on, clicking or unclicking the box will change the cell value, alternating between true and false. Use that value to affect other dynamic formulas, as needed.

HTH