LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,452
Default Userform height not consistent?

OK, so this is a known problem.
It is just that this is the first time I have come across it and I have
dealt with userforms
on different machines a lot.
Apart from as you say leaving plenty of wiggle room there isn't much you can
do about
it as according to the figures all is fine.
Would there be a way to detect what is going on with the Windows API?
Probably not as most (or all?) Userform controls are not windows.

RBS


"Bob Phillips" wrote in message
...
I have certainly had a problem in resizing dynamically that doesn't
necessarily show all the controls fully on some machines. I have just
learnt
to leave plenty of 'wiggle room'.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"RB Smissaert" wrote in message
...
Using Excel 2000 to 2003.
Have a userform where the height seems to show differently on different
machines.
I say show because the actual figures are always the same.
The height of this form is 312.
Then there is a Treeview with a Top of 46 and a Height of 312.
Then there is a frame with a Top of 361 and a Height of 36.

Now the difference is in the bit of the form below the frame, so between

the
bottom of the frame and
the bottom of the Userform.
On one machine (Windows XP, Excel 2002) this bit is fine, but on another
machine (Windows 2000, Excel 2003)
this edge is a bit too big, by about 5 points.
When you look at the figures though it should be fine as these are the

same
on both machines.

Is this a known problem or is there something strange going one here?
Thanks for any advice.


RBS




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Row Height stopped growing and Auot-Fit Row Height does not work PSULionRP Excel Discussion (Misc queries) 0 May 19th 09 07:59 PM
Dates not consistent Nev Wood Excel Discussion (Misc queries) 3 September 30th 08 01:43 PM
Sub-Totals not consistent Tia Excel Discussion (Misc queries) 0 March 12th 07 08:53 PM
Keep consistent between two worksheets Hank Excel Discussion (Misc queries) 1 June 29th 06 04:04 AM
UserForm Change Of Height Rockee052[_57_] Excel Programming 3 March 6th 04 07:47 AM


All times are GMT +1. The time now is 02:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"