Greetings. I am fairly new to Excel programming so I hope this isn't too
basic a question:

I am creating a form with a combobox. The combo box is going to be
populated with items contained within an array.

I would like for the items appearing in the combo box to be sorted into
numerical or alphabetical order. Is that a property inherent in combo boxes
or can I code the thing somehow to pre-sort the data? The only thing I
could think of offhand was to create a worksheet range with the same number
of rows as there are items in the array, drop the array items into the range
and then sort that using excel's sort feature, and then put the range data
into the combo box. That seems awfully convoluted, so I figured there must
be an easier way.

Thanks for the help.