checkbox size

Printable View

03-26-2009, 01:35 AM
saledan

checkbox size

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
03-26-2009, 02:44 AM
nirvana_1

Try this

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
03-26-2009, 07:29 AM
saledan

Quote:

Originally Posted by 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

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
03-26-2009, 07:39 AM
nirvana_1

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

CheckBox1_Click event.
03-26-2009, 08:14 AM
saledan

Quote:

Originally Posted by nirvana_1

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