Does anyone know how to programmatically change the ListRows property of a
Combo Box?

Using VBA I would like to run a Distinct query against a DB (which I can
do). That query will return values to a Dynamic Named Range, whose Row Count
provides the value for the ListRows property of a Combo Box (with a preset
maximum of 20).

Thanks for your assistance in this regard.

Michael