Read Files from a folder into an Excel drop down list or Combo Box

[dhstein]

Can anyone point me to a link that might have an explanation of how to read a
folder and present the file names in a drop down list or a combo box ?
Thanks for any help you can provide.

 

[dhstein]

Can anyone point me to a link that might have an explanation of how to read a
folder and present the file names in a drop down list or a combo box ?
Thanks for any help you can provide.

I figured it out - no need to respond

 

[JB]

With ComboBox:

Private Sub ComboBox1_DropButtonClick()
folder = ThisWorkbook.Path & "\" 'Adapt
file = Dir(folder & "*.*") ' first file
Do While file <> ""
Me.ComboBox1.AddItem file
file = Dir ' next file
Loop
End Sub

http://cjoint.com/?bssO7gdJrj

JB
http://boisgontierjacques.free.fr