Combo Box Data

J

Jim Berglund

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
 
S

Stusk

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.
 
Top