Results 1 to 13 of 13

Thread: Control fonts

  1. #1
    matt
    Guest

    Control fonts

    I have put a tick box control onto a worksheet. How do I change the font of the text of this control?

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Control fonts

    Hi,
    If you right-click on the control and choose Properties, there is a font option in the properties list which allows you to change font, size and style etc.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    matt
    Guest

    Re: Control fonts

    Is that an Excel 2000 thing? I don't see a font option when I do that (excel 97)

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Control fonts

    To be honest, I can't recall. Do you get the properties window appearing? If so, what options does it list?
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Control fonts

    Matt,

    I tried the same thing in Excel 97, and it works- but are we talking about the same thing?

    There's 2 sorts of checkboxes in Excel- one from the forms toolbar, and one from the control toolbar. The one from the control toolbar works as described- to be honest- although I kbow the "forms" toolbar from Word backwards- I'd never tried it in Excel until now- so I cannot answer that one. I'm just trying to clarify what we're looking at.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  6. #6
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Control fonts

    Oops!
    Thanks for pointing that out Geoff! I'm so used to using the control toolbox that I'd forgotten about the Forms toolbar! I don't think you can change the font if the checkbox came from there, sadly.
    Regards,
    Rory

    Microsoft MVP - Excel

  7. #7
    matt
    Guest

    Re: Control fonts

    Ah hah!

    The tick box control on the 'controls' toolbox does have font properties. The tick box control on the forms toolbar doesn't (or at least I cannot find them!).

    Thanks for your help - in future I will use the controls toolbox.

    We live and learn.

    Matt

  8. #8
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Control fonts

    Matt,

    I'd be interested to know how you go.

    I'd experimented with controls from the "Controls" toolbar in Word, and found enough problems (at least way back when) that I didn't want to go ahead with them. Sure, they were infineitely more flexible than the Forms control (it took me a littlw while to work out that I had to click on the blue set sqaure icon to toggle; but under the OS back then (Office 95 + Windows 3.1(?)) it took up a lot of space on the saved files, and did not work very fast.

    Even now, under WinnNT & Word 2K, when you scroll, these "ActiveX" controls do not appear to scroll until you let go of the mouse button- disconcerting for sum.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  9. #9
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Control fonts

    Excuse me if I've not got hold of the thread properly, but If you're in the vbe looking at your form you should be able to open up a properties box either from the standard toolbar or by right clicking on the offending checkbox and one of the properties displayed should be font.

    HTH

    Brooke

  10. #10
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Control fonts

    Hi Brooke,
    Unfortunately for matt ([img]/w3timages/icons/grin.gif[/img]), he was putting the checkbox directly onto a worksheet (not on a userform) and he was using the one from the forms toolbar, rather than the control toolbox, and that one doesn't have a font property.
    Regards,
    Rory

    Microsoft MVP - Excel

  11. #11
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Control fonts

    Ok, so I didn't have hold of the thread! Ignore me and I'll go away, honest.

    Brooke

  12. #12
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Control fonts

    nor did I until Geoff pointed out I was talking about the wrong thing![img]/w3timages/icons/grin.gif[/img]
    Regards,
    Rory

    Microsoft MVP - Excel

  13. #13
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Control fonts

    Hmm. I always thought there were two types of checkbox for excel.... now it turns out there are three? I'd best go read the manual again.

    Brooke

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •