Userform Textbox Font Size Changes

[Remsai]

Hello,

I've tried debugging this problem in every which way possible. I can't seem to fix it, it always comes back.

The problem is that the font size of some of the textboxes always goes as size or two down. (Attached Screenshots)

After searching everywhere on the internet, I can't find an answer.

There doesn't seem to be a question quite close to mine or the answer is that it is an excel bug.

Thanks

Here is the textbox code: (As you can see font size is stated)

c = 1
For r = 1 To 12
            Set Myctl = MultiPage1.Pages(0).Controls.Add("Forms.Textbox.1", "r" & r & "c" & c, True)
            Myctl.Height = 20
            Myctl.Width = 35
            Myctl.Top = (h - 1) * (r - 1)
            Myctl.Left = 0
            Myctl.BorderStyle = 1
            Myctl.TextAlign = 2
            Myctl.Font.Size = 8
            Myctl.BackColor = RGB(146, 208, 80)
Next

 

[NdNoviceHlp]

Maybe...

With Myctl.Font
.Size = 8
End With

HTH. Dave

 

[Remsai]

Thanks Dave.

I've tried it and it was the same. It's still changing sizes.