List display in userform

Quick question, I believe, How do you display lists within a label on a userform. Right now this is only displaying 1 cell. I need to have the background data in list form as I will be filtering it within the form later.

Please Login or Register  to view this content.

Also, if not a label, what would be the best way to display the list, as it will expand in future and something with a scroll would be prefered.

Thanks.

As a quick reply, this is what I did for my list

Please Login or Register  to view this content.

you can also make dropdown list in a cell, using data->validation. Only thing is if you refer another sheet for list contents, it should be a named range

rgds

johnjohns

Sorry, forgot to mention, I used list box, not label

rgds

johnjohns