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.