Fill listbox with values from an other worksheet...

Is it possible to fill a listbox on worksheet wsB with values which are located on worksheet wsA?

I can't get it through the data validation option because then the values have to be in the same worksheet.

I assume you mean A dropdown menu if you are using a list from data validation


Go to Insert,Name,Define,,Put in a one word name such as
FromOtherSheet
in the reference box enter the range from the other sheet

=[test2.xls]Sheet1!$A$1:$A$4


goto data validation,list

in the refrence box enter

=FromOtherSheet


it appears that this only works if both workbooks are open