adding item to list box?

Hello,

My question is about adding items to a list box.

I want to add items to a list box from an array. Not a range on a worksheet. How do i do this?

So far I've created a form called frmTest. I've made a list box on the form called lboChoices. I've clicked on the lboChoices and have opened up the sub code for the List Box.

My array is called strArray. It's been sized to hold 5 values. One value for each element. The values are "1" "2" "3" "4" "5", respectively.

Please Login or Register  to view this content.

Thanks for the help! I can't figure out the way to use the additem method even with looking at the excel Help for some reason.

Looking forward to understanding how this works!