Populate listBox

H

Hamster

Hi All

How do I go about populating a listbox. with file names from a directory. I
can do this in VB but can't find anything in excel


thank you
Phill
 
T

Tom Ogilvy

Dim sPath as String
Dim sFname as String
sPath = "C:\Myfolder\*.xls"
sFname = Dir(sPath)
Do while sFname <> ""
Listbox1.AddItem sFname
sFName = dir()
Loop
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link a text box based on drop down box with four options MS Word 365 0
Auto populate value from one task to another in MS PROJECT 0
Populating a listbox from an excel column 2
Populate listbox with disconnected recordset? 5
Open form 0
Firing Event in another user form 1
Blank item in listbox, how to remove 3
Wrapping entries in a ListBox 1

Top