Listbox rowsource in personal working folder

[Jurg55]

Hi,
Im trying to create a listbox in my personal working folder.
Normally the data is already in the workbook so you can select the cells and link this to the listbox rowsource. But now I want the rowsource in the code itself and not in the workbook. I dont want the data in the workbook. How can I make a listbox with the rowsource stored in the personal vba code?

Thank you!

 

[NateSC]

If you are creating the listbox in VBA already and are using something like:

ListBox1.List = Range("A1:A5").Value

then you can hard code the values one at a time with

ListBox1.AddItem "Apples"
ListBox1.AddItem "Oranges"

or all at once with somehting like

ListBox1.List = Array("Apples","Oranges","Pears")