Combo Box row height

Hi,

I created a ComboBox on a multi-page user form and the Row Source is a dynamic range name. How do I get the ComboBox drop down length to match the height of the dynamic range? (The shortest range height is 2 rows and the longest is 12.)

Thanks,

Lawrence

Originally Posted by Palmetto

Perhaps this, adjust sheet/references as needed:

Please Login or Register  to view this content.

Thanks for the reply!

Two questions. First, since the source range is a dynamic range name, can I substitute the range name for

Please Login or Register  to view this content.

Also, does this code go into/between the following:

Please Login or Register  to view this content.

Thanks again!

Lawrence