You can do it two ways.

1) Manual - go to the VBA menu and view properties window and in RowSource
box add something like sheet1!A1:A10
2) From code. It is similar to the manual mode.
Listbox1.RowSounce = "sheet1!A1:A10"

"eggpap" wrote:

Sorry Joes,

I think to have been not clear in my request.
I referred to the listbox control on an user form.

Thanks,
Emiliano