I finally found a solution that I could make work:

Sub PickFiles()
Dim lngCount As Long
' Open the file dialog
With Application.FileDialog(msoFileDialogOpen)
.AllowMultiSelect = True
.Show
' Display paths of each file selected
For lngCount = 1 To .SelectedItems.Count
Worksheets("FileSelection").Select
Cells(lngCount + 8, 6).Value = .SelectedItems(lngCount)
Next lngCount
End With
End Sub

The user clicks a button that I assigned to this macro. Might not be a very
elegant solution, but works well enough for my application.
Thanks for the suggestions,
Rob

"Steve Yandl" wrote:

Rob,

Is your plan to have the list of files available as soon as the userform is
activated or is the user going to do something else that will trigger the
listbox update (for example, selecting the folder where the files are)?

Is the user only going to be presented files in the folder or might there be
subfolders as well?

Steve Yandl


"br549" wrote in message
...
I have a little experience manipulating data in Excel using VBA, but no
experience with userforms. Is there a relatively simple way to fill a
listbox
with the contents of a folder so the user can be presented with a choice
of
files that will be used for some calculations? Goal is for user to select
a
file from the list box, then the VBA code will pull certain data out of
that
file for a calculation.

Thanks,
Rob