checkbox size

[saledan]

Hello,
do you know a tip to resize a checkbox?
Because i have to insert checkboxes in a grid (5,2) but with font size 10/12 the checkbox area covers the near checkboxes.
I can reduce up to 0,61cm but i cannot reduce more.. and my row height is 17pixel..

Please may you help me?

Many thanks
Cheers
Max

[nirvana_1]

If your checkbox is named CheckBox1 then you can use the height and width properties to set the sizes. e.g. when you click the checkbox you want to re-size it. use the code below.

Private Sub CheckBox1_Click()
CheckBox1.Height = 30
CheckBox1.Width = 100
End Sub

[saledan]

If your checkbox is named CheckBox1 then you can use the height and width properties to set the sizes. e.g. when you click the checkbox you want to re-size it. use the code below.

Private Sub CheckBox1_Click()
CheckBox1.Height = 30
CheckBox1.Width = 100
End Sub

Sorry, i forgot to say that i use control from forms .. and i cannot use any macro, because there's a strict policy

Many thanks

[nirvana_1]

This control is on the userform itself it is not a seperate macro.

CheckBox1_Click event.

[saledan]

This control is on the userform itself it is not a seperate macro.

CheckBox1_Click event.

yes, but i cannot run any macro.
All macros are blocked.

I can try with right click on checkbox, then selec Format Control, Size and set for example height: 0,40cm, then click on OK. and the checkbox don't change the size, and into the properties, the size is back to 0,61cm as default value


Sorry about my bad explanation
And thanks for your patience and answers

Many thanks