when designing my userform, I was using 1024x768 screen
resolution. then it dawned on me that there will be
people using the form at 800x600. which of course changes
everything... rookie mistake. lol i was hoping there was
an easier way then testing each resolution and using case
statements. thank you for your help.
-----Original Message-----
Jim,

I haven't tried myself but I would have thought this is
very simple to do.
Have you tried to just set it according to your algorithm
in the Userform
initialise or activate event code, such as

Combobox1.ListRow = 32

or within a Case statement when you have determined your
userform size with
a test based upon that size.

Is that helpful, or have I missed the crux of the
question?

--

HTH

Bob Phillips

"jim C." wrote in message
...
Im creating a userform that list a multicolumn range in
a
combobox. This user form will be used on different
computers with different resolutions. I use windows
api's
to add maximize button to form. I would like tto put
the
combobox at the top of the form and use the maximum
amount
of screen space to dispay listrows. is there a way to
make the list rows property relative to screen size or
userform size. right now i am trying "if then" with
different resolutions ie: if resolution is 800X600 then
listrows = 32 so on and so forth... any help would be
appreciated.


.