Text Boxes in a User Form

  • Thread starter Thread starter Chris Gorham
  • Start date Start date
C

Chris Gorham

Hi,

I've designed an Add-In which has some UserForms with
textboxes in them...
However, when I designed them they are perfectly sized
such that the text is fully displayed. However other
people have found that the text is not displayed fully -
and requires them to select the box inorder to scroll
through the last lines of text.
Anybody know whats happening here...??

Rgds

Chris
 
It could be that you're using a font that they don't have. When XL
substitutes for that font, it may be choosing a bigger typeface. Make
sure your font is a standard system font.

If your users use Macs, this will be caused by the different screen
resolutions. Macs use the typographical standard of 72 dpi (i.e., 1
pixel = 1 pt, with 72 points per inch), while Windows, for some reason,
uses 96 dpi (1 pixel = 1.333 points). So a userform perfectly sized for
Windows looks scrunched on a Mac, and the text (specified in points on
both platforms) will be proportionally bigger.
 
Back
Top