add items to a list box

M

mike

trying to create a simple list box in excel '07

-from developer ribbon, i select insert, list box, then draw the box

-unable or not sure where to "add items" for my list box?

any advice is appreciated...thx.
 
O

Office_Novice

Search VbA help files for .AddItem

Should be Somthing like this

With ListBox1
.additem = "Item"
End with
 

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

keyboard up/down arrows to select items in this list box 3
Copying List box values/selection to a database of sorts 2
select items in a list box with a macro? 3
List Box 1
Access Cannot select items in listbox 1
Dropdown list items and item IDs 1
Getting list data into spreadseet 2
Array as Source for List Box 4

Top