ActiveX text box changes font size depending on selection status

[Special K]

I have an ActiveX text box that displays text from external text files. This works correctly, but the font size of the text changes depending on whether I am selecting inside the text box (including the vertical scroll bar) or not. When the text box/scroll bar is not selected, the text is smaller than when it is selected. Is there any way to prevent this behavior?

 

[Yongle]

Unable to mimic what you described - text size remains identical regardless of what I do

You could try this (pure stab in the dark and will probably make no difference!)

Private Sub TextBox1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
    TextBox1.Font.Size = 12
End Sub

1. Which is the correct size?
- when selected? or when not selected?

2. Try making the text twice as big
- does the same thing happen?
- is the "incorrect" size the same as before or has it also doubled in size?

3. Try a textbox without a scrollbar
- does the same thing happen

4. Which version of Excel are you running?

 

[Special K]

Unable to mimic what you described - text size remains identical regardless of what I do

You could try this (pure stab in the dark and will probably make no difference!)

Private Sub TextBox1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
    TextBox1.Font.Size = 12
End Sub

1. Which is the correct size?
- when selected? or when not selected?

2. Try making the text twice as big
- does the same thing happen?
- is the "incorrect" size the same as before or has it also doubled in size?

3. Try a textbox without a scrollbar
- does the same thing happen

4. Which version of Excel are you running?

1. The font is larger when I select inside the text box. I am not sure which one is the "correct" font size.

2. If I make the font twice as big (22 vs 11), the font expands in the X direction only when I click inside the text box.

3. This behavior occurs even without any scrollbars.

4. 2010

 

[Special K]

Bump - anyone else?

 

[Special K]

Bump - anyone else?

I don't seem to be able to edit my previous post, so I'll add this:

This behavior also seems to occur with buttons - the label font size increases when the button is selected vs. when it is not selected.