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.