Odd behaviour of Fonts in Userform Labels

[TonyJollans]

Hi All,

Sorry for the second post but I screwed up and didn't give the first one a proper title. Please ignore the first one - the content of both is the same.

I am finding some odd behaviour with Userform controls in Excel 97 and would appreciate any help anyone can give me as I learn what to do.

If I open a new workbook and create a new userform and a add a single label it has a default font of Tahoma 8-point which I am quite happy with (I don't know if there's any way to change the defaults, nor do I care at the moment).

If I now change (via the Properties box) the Height to 10 and the Top to 10, the displayed text changes to what appears to be Tahoma 10-point. The font property itself remains unchanged.

Playing around a bit I found that Height 14 and Top 14 change the text to 7-point and various other combinations have various effects, such that precise positioning of labels so that they are aligned might cause one of them to have a different font from the others.

As you might imagine this is very frustrating. Is this a 'feature' or might there be something in my setup which I can change to stop it happening? I have tried on three different computers - all with Excel 97 but with different versions of Windows.

Any insights gratefully received,

Thanks in Anticipation,

Tony

 

[xlbo]

D'oh - already posted in original post - don't get all excited tho 'cos I don't know the answer Rgds
Geoff

Vah! Denuone Latine loquebar? Me ineptum. Interdum modo elabitur

 

[RobBroekhuis]

I've seen something like this before. I think what worked for me was to (after all other changes) reset the font size property. Even if it was already 8 point, assigning 8 to the font size changed the physical appearance of the font on the form. My situation was a little different from yours, but it's worth a try.
Rob

 

[TonyJollans]

Rob,
Tried that, I'm afraid. Also tried changing it to something else and back to 8 and it still didn't work.

Geoff,
Sorry about confusion with double post - I have seen your post in other thread and await any feedback, thanks.

Tony

 

[RobBroekhuis]

I can't reproduce this in Excel2000...
Rob

 

[xlbo]

I can in 97 - still no replies from the list tho. will let you know if and when I hear anything Rgds
Geoff

Vah! Denuone Latine loquebar? Me ineptum. Interdum modo elabitur