View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
br549 br549 is offline
external usenet poster
 
Posts: 13
Default directory listing in listbox

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