Font Size in Labels on Forms

C

Craig Coope

How can I change the font size on a label in a form. There is no
obvious option (in 97').

I have tried font.size = 12 etc to no avail...

Cheers....
 
C

Craig Coope

This worked in xl2003:

Me.Label1.Font.Size = 12
Click to expand...

Cheers for that...

OK I am a novice when it comes to VB but the font is only large after
I click on it...I assume it is to do with the coding for the label to
change when a user clicks on it but how do I get to to stay as I want
from the very start?
 
D

Dave Peterson

Go into the VBE.
Show your userform
rightclick on the label
choose properties
Look for font in the properties window
Double click on the font name (Tahoma???)
Change the font size there

Remove any code that you used to specify the font size.

======
My bet is that you didn't have it in the correct procedure. I'm gonna guess
that you put it into some _click event. And I think userform_Initialize would
be better.

But once you change the properties, you can delete any code (well, unless you
really want to change it from the size you made it).
 

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

Similar Threads

How to modify and updte specific styles for specific paragraphs across the document 0
Footer text appears "squished" 1
How can the font and size of (all) citation numbers be altered? 1
cannot find which label format i need 1
Need help modifying code 0
Trying to create custom labels from an csv file + Need items numerically counted out 0
Word Template and Normal Style 1
Text in note pane of "normal" display suddenly much larger 1

Top