Listbox1 If Statement

[sparx]

I am struggling to re-list the contents of a userform listbox once its filled, does anybody have any experience using them?
The code runs when my userform activates and lists all the files within a specified folder & a wildcard lookup which works fine.

fName is the folder location on my hard drive in sheet1.
lookup is the part of a filename of text files I am trying to search through, matches list inside ListBox1 matching the word "Online" or "Offline"

Please Login or Register  to view this content.

If I repeat the above code to another userform button, I get a runtime error 9.
I am trying to re-list the contents of ListBox1 array, maybe the code can not be used this way.
Any help is much appreciated.

[6StringJazzer]

First, it is not necessary to store the filenames in an array then copy them to your listbox. Are you using that array anywhere else? You can populate the listbox directly. However, that is not causing your problem.

It would help to know which line of code is shown when you get the error. Regardless the problem is likely that you are not clearing out the listbox before repopulating it. Try this version.

Please Login or Register  to view this content.