Combo Box Data

  • Thread starter Thread starter Jim Berglund
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combo box - last value 2
combo box 2
Problems with a Combo Box 2
Having trouble with combo boxes. 11
Combo Box and Multiple row / column display 2
Data Validation - Combo Box open with single click 0
data as a combo box or list box 3
Combo Box Data Validation - First Entry Blank 2

Back
Top