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

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.

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

"dhstein" wrote:

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

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

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

On 16 jan, 11:15, dhstein wrote:
"dhstein" wrote:
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- Masquer le texte des messages précédents -

- Afficher le texte des messages précédents -