title: excel vba listbox additem
body: <p>I am running office 365 home on windows 10. I am programming Excel using VBA.
  I have a data range in a worksheet row. I want the user to be able to select one item from this row of data. I am trying to populate ListBox or ComboBox with dta from the range row. Having read MS vba.reference documentation I decided to get my range data into an array and use listbox = myarray() and got &quot;Object does not support this method or property.&quot; I tried looping through my data range and putting each item in using listbox.additem (mydata()) with the same result. On examination of the listbox prperties AddItem is not there. Seems they have been withdrawn or maybe never existed for Excel VBA.
  Any suggestions?</p>