PDA

View Full Version : checkbox size



saledan
03-26-2009, 01:35 AM
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
03-26-2009, 02:44 AM
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
03-26-2009, 07:29 AM
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
03-26-2009, 07:39 AM
This control is on the userform itself it is not a seperate macro.

CheckBox1_Click event.

saledan
03-26-2009, 08:14 AM
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