UserForm differences between Excel 98 and X

[Jason Morse]

I have a lot of macros written in Excel 98, which I've been trying to
fix to work with Excel X as well (some of my macro users have gone to
OS X, while others remain in OS 9).

One of the most annoying issues is that Userforms appear so
differently between the two versions. They don't need to be exact for
my purposes, but the width of the form is much smaller in X, which
truncates some of the items on the form. Oddest of all, the userform
looks OK in the VBE (i.e. it looks more like it does in Excel 98).
But at runtime, the right side is truncated by about 50 pixels (based
on a half dozen that I've looked at so far).

I will probably use some of the same techniques that I've seen posted
for adjusting forms on the fly for Windows/Mac compatibility, but I'm
just wondering... Why does the same userform display so differently
between Excel 98 and Excel X ?? (BTW, I'm comparing Excel 98 running
through Classic on the same computer, so it has nothing to do with
monitor resolution, etc.)

Thanks for any comments.

 

[Jim Gordon MVP]

Hi Jason,

This is a pretty esoteric bug. Please don't laugh, but I think you might
have your dock on the left. If you move the dock to the bottom or right
side the problem should go away.

This is a known issue. I'm sure it was fixed in Excel 2004, and it may
have been fixed in the service release for Office X.

-Jim Gordon
Mac MVP

 

[Jason Morse]

Absolutely correct. Thanks, I never would have gotten that one.

I've got all the Office X updates installed, but I haven't upgraded to
2004 yet. Either way, I just feel better knowing the cause.

Thanks again.
-Jason