ListBox Using VBA

"Teach a man to fish..." version of the answer:

download the userform training from here:

http://www.theofficeexperts.com/downloads.htm

...for lots of examples...post back if you need more.

I looked at the first example but I must be missing something. There seems to be only one line of code. Where is the January - December read from and I don't have a scroll bar. Please elaborate

I have created a userform and added a listbox to it. Since, I've never done a listbox in VBA before, when will I see the scroll bar and where does the data go to allowing the user to scroll through and select ?? I know this probably very easy but I'm claiming stupidity !!!

Aloha...

I understand your confusion! Helpful examples if you can figure out how to get around.

If you go to VBE and open the first userform with a list box (the one with the months), click the userform (not the list box) and click Run, you should get a running version of the list box form, scrollbars and everything.

If you have the userform open in VBE, select one of the list boxes, and look in the Properties window, you should see a property way down that says RowSource. It shows that the months come from a workbook sheet called listsheet, and the cells used for the list are a1:a12.

So if you leave VBE and go into the worksheets one is called TableOfContents, the other is ListSheet.

Click on the ListSheet tab, and you'll see the lists the author uses to add items to his/her forms.

Does that help?

(Thanks for the link, PaddyD!)

Tana-Lee

Thanks so much you couldn't have made it any clearer !!!!

Aloha Part II....

You're welcome.

I was in a hurry the other day, so I didn't take time to mention the other list box example from the link above.

Did you see it? It's the second one in the table of contents in the userform training download.

It demonstrates several ways of loading data into list boxes.

Let me know if you saw it or need more direction to it.

Tana-Lee