Forum Discussion
Solved
UserForms are getting strange, please help.
This must be the weirdest phenomenon I've ever faced. Normally in Userform.ListBox.Font.Italic should works just like a range. Private Sub UserForm_Initialize()
'this would works as expected
Us...
- Gosh, I finally figured it out.
Turns out it all comes from the 64-bit Office. I tried to uninstall my office then reinstall 32-bit and it works PERFECTLY. >_<
I mean, come on Microsoft. It's 2022, I've been deploying 64-bit office to my colleague since 2016. And I don't regret it at all cause 64bit is sensible faster than 32bit to my workflow.
Guess the best workaround would be Call .font. Italic = false at others module. Thanks for your response ~
I cannot reproduce the problem. Even if I don't call fixed, the listbox font is not italic when I show UserForm2 and UserForm3.
I'm using Excel in Office 2021 on Windows 11. Which version of Office and which operating system do you use?
What!
i have 3 devices, Windows 10 with Office 2016, Windows 10 with Office 2021, Windows 7 with Office 2010. All of them behaves the same issue ....here's a footage....
Oh, I don't doubt your experience at all. I've seen more than enough weird behavior...
- Gosh, I finally figured it out.
Turns out it all comes from the 64-bit Office. I tried to uninstall my office then reinstall 32-bit and it works PERFECTLY. >_<
I mean, come on Microsoft. It's 2022, I've been deploying 64-bit office to my colleague since 2016. And I don't regret it at all cause 64bit is sensible faster than 32bit to my workflow.
Guess the best workaround would be Call .font. Italic = false at others module. Thanks for your response ~