Try something along the lines of

Dim WB As Workbook
For Each WB In Application.Workbooks
Me.ListBox1.AddItem WB.Name ' or WB.FullName
Next WB



"anamarie30" wrote in message
...
I need to add to my main workbook a listbox that show or contain the names
of
workbooks that user had open in the computer. The purpose of this is allow
the user to select one workbook instead of write the name of it for doing
a
performance analysis. How can I do that?