I have a Excel (XP) combo box which lists data from a changing source. The
number of entries may vary every time the code is run. The Properties
function gives me a data target, but doesn't give control over a
variable-length list.

What is a VB approach for handling this?

Thanks,

Jim Berglund

I might be tempted to look at a statement of the form

UserForm1.ComboBox1.List=Array

where Array contains the list of data you wish to have displayed.

"Jim Berglund" wrote:

I have a Excel (XP) combo box which lists data from a changing source. The
number of entries may vary every time the code is run. The Properties
function gives me a data target, but doesn't give control over a
variable-length list.

What is a VB approach for handling this?

Thanks,

Jim Berglund