add items to a list box
 

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.

add items to a list box
 

Search VbA help files for .AddItem

Should be Somthing like this

With ListBox1
.additem = "Item"
End with



"mike" wrote:

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.