mcgilvra
asked on
Font size reducing by itself in a list box.
We wrote a VBA app under Excel 2010. A particular user on an XP machine is seeing the font size in a list box reduced to almost unreadable size. The list box font property is set to Arial 12. Another user on an XP machine cannot replicate the problem. And the developer, myself, cannot reproduce it on a Win2007 machine. Attached is a screenshot of the reduced font list box.
Any help would be greatly appreciated, thanks.
Any help would be greatly appreciated, thanks.
The font file on the particular machine might be damaged. How does that font appear in other contexts?
I assume that the control is on a sheet and that you are using an ActiveX listbox rather than a forms listbox. If so that's a known problem when using ActiveX controls on a sheet which they really aren't designed for. On the other hand, the problem with using a forms listbox is that while the font size won't change, it is set at a small size that can't be changed. There's another option however which is described in my Magical Floating ActiveX Control article. And yes, it uses ActiveX controls but you won't experience the shrinking font problem because the listbox will be recreated each time.
ASKER
List box is located on a worksheet. List box was created from Controls (not forms). List box text entries are added via VBA code. I'll have to check on font appearance in other contexts. Screen shot is now attached.
20140825-122930.jpg
20140825-122930.jpg
I assume that you chose the control at the arrow. If so then please see my previous post.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I'll bet that after several clicks that while the size of the listbox will be restored that the size of the font will shrink.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Where is the listbox located and how did you create it?