Userforms and lists

Posted by M Walker on July 05, 2001 5:02 AM

Hello,

I'm just coming to grips with VBA but have come across several problems.

I'm trying to introduce a list into a userform. I've named a range of cells as "description" but can't seem to add this items into the form.

I'm getting very confused...

I'm also trying to check another range of cells for specific values which would cause them to be listed in another list box on a sperate form. This would then need to be printed out.

Any help would be appreciated,

Thanks

Matt

Posted by Ben O. on July 05, 2001 7:20 AM

Matt,

To add those items to a userform, you must create a listbox or combobox on the form. In the properties of the listbox or combobox, type in "Description" as the RowSource.

I can't help you with your second question, but I think you need to give a little more detail in order for anyone to help you.

-Ben O.