PC Review


Reply
Thread Tools Rate Thread

Can the sixe of the checkbox activeX be changed?

 
 
perfection
Guest
Posts: n/a
 
      8th May 2007
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!

 
Reply With Quote
 
 
 
 
=?Utf-8?B?Sm9obiBXaWxzb24=?=
Guest
Posts: n/a
 
      8th May 2007
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.
--
Amazing PPT Hints, Tips and Tutorials-http://www.PPTAlchemy.co.uk
http://www.technologytrish.co.uk/ppttipshome.html
email john AT technologytrish.co.uk


"perfection" wrote:

> 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!
>
>

 
Reply With Quote
 
=?Utf-8?B?Sm9obiBXaWxzb24=?=
Guest
Posts: n/a
 
      8th May 2007
I should have added that this can be done without vba in XP onwards using
triggered entrance and exit animations

some ideas on triggers http://www.pptalchemy.co.uk/Triggers1.html
--
Amazing PPT Hints, Tips and Tutorials-http://www.PPTAlchemy.co.uk
http://www.technologytrish.co.uk/ppttipshome.html
email john AT technologytrish.co.uk


"John Wilson" wrote:

> 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.
> --
> Amazing PPT Hints, Tips and Tutorials-http://www.PPTAlchemy.co.uk
> http://www.technologytrish.co.uk/ppttipshome.html
> email john AT technologytrish.co.uk
>
>
> "perfection" wrote:
>
> > 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!
> >
> >

 
Reply With Quote
 
Brian Reilly, MVP
Guest
Posts: n/a
 
      5th Aug 2007
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

On 8 May 2007 02:01:39 -0700, perfection <(E-Mail Removed)>
wrote:

>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!

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Resizing an activex checkbox control Blue Max Microsoft Excel Worksheet Functions 2 13th Dec 2008 10:29 PM
Write conflict when a checkbox is changed and changed back on pop upform Dont.Spam@trashymail.com Microsoft Access Forms 4 16th Sep 2008 06:13 PM
Can you filter on an ActiveX checkbox in Excel =?Utf-8?B?TGl6?= Microsoft Excel Misc 1 13th Aug 2005 12:29 AM
ActiveX checkbox resizing Andrew Bell Microsoft Word Document Management 8 14th Apr 2004 02:45 PM
Can't check ActiveX checkbox on worksheet onedaywhen Microsoft Excel Programming 3 9th Aug 2003 02:34 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:17 PM.