Can the sixe of the checkbox activeX be changed?

P

perfection

I was looking forward to using the checkbox activeX control for my
quiz and learnt sufficent to perform like chaning font colour, sizea
nd box dimensions and insert image but to my great amazement i could
not find a property to increase the size of the checkbox itself which
i feel is ridiculously small for most situations. I googleda around
and yet did not find a solution. There were hints that this can be
done with a few lines of VB code scripting but i could come up with
nothing.
My query is - is it true that the size of the default checkbox cannot
be changed IN ANY WAY AT ALL and if it can please let me know how - i
have been tearing my hair out to find the bottom line on this issue!
 
G

Guest

I don't think there's any way to change the size of the activx checkbox. You
can easily make your own though bny simply drawing a rectangle and right
clicking and choosing add text (no need to add any)

vba to control would look something like this

Sub chequer(oshp As Shape)
If oshp.HasTextFrame Then
With oshp.TextFrame.TextRange
If .Text = "X" Then
..Text = ""
Else: .Text = "X"
End If
End With
End If
End Sub

Make sure that the shape(s) you draw has an action setting of "run macro".
NB this code will only work in show mode.
 
B

Brian Reilly, MVP

In addition to John's comments, he is correct that there is no way to
change the size of the actual checkbox but you can change the size of
the clickable area that will check/uncheck the checkbox.

Change width and height Properties of the checkbox and change the
color of the Background to make it more visible for the user. Now,
clicking on any area of the background will change the checkbox to
checked or unchecked. If you have code associated to the OnClick
event, that will fire on clicking the background area.

Brian Reilly, MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top