add items to a list box

  • Thread starter Thread starter mike
  • Start date Start date
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.
 
Search VbA help files for .AddItem

Should be Somthing like this

With ListBox1
.additem = "Item"
End with
 
Back
Top