Do you mean ListFillRange (worksheet control), or RowSource (userforms)?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Neil" wrote in message
...
What is the property that makes the list width in a combo box fit the
sources?