#15- How to resize CheckBox in Excel VBA | Learn Excel VBA | MsOffice Learning | រៀន Excel

[@civilross]

Sub resizecheckbox(ByRef indexVal As String) If Range("A" & indexVal).Value = Range("B1").Value Then Range("A" & indexVal).Value = Range("B2").Value Else Range("A" & indexVal).Value = Range("B1").Value End If End Sub Sub check1() Call resizecheckbox("1") End Sub Sub check2() Call resizecheckbox("2") End Sub

[@marilyncook2704]

How do you hide columns A & B without it affecting the check boxes. Every time I try it the check boxes disappear.....

[@dteshaev]

Great info! Thanks, took me a bit to figure out the sub routines as my symbols were not in A1, B1 but different spots.

[@hafizsanee8929]

Thanks for your video.. its save my day.. Lets say i have 10 checkbox, so i have to repeat the "subcheck() callcheckbox(1)" 10X until callcheckbox(10)? I also have tried this, but few check box very difficult to allign vert & horizon because the crop size is not same for each checkbox? Any solution sir?

[@albertoguerrero5362]

Thanks for posting this. Fantastic.

[@andrewcraigo1623]

I get a "Sub not defined error" for Sub check1 () and Sub Check2 (). I copied exactly as it is written in your video. Please help!

[@seawolf1868]

Thank so much for the good lesson sir.

[@eddiemendez4766]

This is a little confusing without some explanation. So if I have a document that requires checkboxes, do I need to create the VBA code for each individual cell that has a checkbox? And then assign each checkbox its own macro? If I copy and paste the already created checkbox with its macros, will that copy work independent of the source of the copy? Please help explain

[@Krustee78]

I would think you only need to code for the on off then can copy and paste special for each check box. Need to do this for three sets of yes no boxes so gonna run and do it to see

[@Krustee78]

Essentially you have to code each individual check box and this setup is showing what would be used for a yes/no or 2 box setup. If you have multiple 2 box setups you can’t just copy and paste the check boxes. You have to go in and copy past the code then where you see 1’s make them 3’s and where you see 2’s make them 4’s and repeat that process. Those are then the macro 3 and 4’s that get assigned to the subsequent boxes. DM me if you need help and I can help you out.

[@rinabinette]

you can code a range

[@tommy0828]

Hey sir how can you clear that using VBA

[@visarmurtezi9237]

How can i make a button to Uncheck all the resized Boxes??

[@hafizsanee8929]

Yeah, i was thinking the same.. how to make a button that can clear all checked button to unchecked... 👍🏼👍🏼

[@ali.sayed3]

I love you 😘

[@justfelicia6671]

lol

[@civilross]

GRACIAS

[@hoodednight7780]

i dont hhave the checked symbol as a option

[@shayjosh5136]

You can find it after selecting "Wingdings" in the Font list

[@PimpLici0us]

Ty

[@satpov4996]

good