Control fonts

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

Hi Brooke,
Unfortunately for matt (), 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.

Reply | Quote

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

Brooke

Reply | Quote

nor did I until Geoff pointed out I was talking about the wrong thing!

Reply | Quote

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

Reply | Quote