Create ListBox and Populate with Array

M

Max

Hi - Help this noob out...

I want to create an array and then take the data contained in that array and
place it in a ListBox so that users can then select values (one to many)
within that List box.

1) How do I create the ListBox?
2) How do I put the data in the the array into the ListBox?
3) How do I capture the selections to be used later?
 
D

dan dungan

Hi Max,

1) How do I create the ListBox?

In Excel 2000,
a) With the mouse, choose Help
b) Type list box in the Answer Wizard box "What would
you
like to do?
c) Click on "Add ActiveX controls from the Control
Toolbox"

This should take care of 1, 2 and probably 3, as well.

hth

Dan Dungan
 

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

Top