Creating listboxes in VBA
Posted by Chris M. on November 14, 2001 5:15 PM
Can someone just give me a sample code that creates a list box and then lts me put the information from this code into it. I tried using the help files to get some examples. All I got was
Set lb = .Shapes.AddFormControl(xlListBox, 100, 10, 100, 100)
For x = 1 To 10
But i'm not sure how to create an object that is a listbox so I can refer the code to it. I'm just begging in the VBA environment so please go easy on me.
I'm trying to get it into this, so I can use it. THis code was offered by someone on this site which I am very gratefull for. I just need someone to show me how to use it. Thanks.
.FileType = msoFileTypeAllFiles
.LookIn = CurDir()
.SearchSubFolders = True 'or false
For i = 1 To .FoundFiles.Count
something.AddItem.FoundFiles (i) 'where something is some listbox somewhere