For ll = 0 To File3.ListCount - 1 1

[kennedymr2]

Is there any way of making the File3. variable

Ie i want to run the for.... using eg File3. File4. File5. etc


For ll = 0 To File3.ListCount - 1

vvv="File3"
?? For ll = 0 To vvv.ListCount - 1

Appreciate any help


Regards Kennedymr2

 

[kennedymr2]

Its all ok seem to have worked it out

Dim fld As String: fld = "File3"
For ll = 0 To Controls(fld).ListCount - 1


Regards Kennedymr2

 

[HughLerwill]

I guess we are talking about FileListBoxes so how about putting them in a Control Array. Then you can then, OTTOMH, do something like;

For i = 0 to MyFileList.Count-1
For j = 0 to MyFileList(i).ListCount-1
'do the stuff
Next
Next

 

[kennedymr2]

HughLerwill

Thanks... yes .... a much better idea..


Regards Kennedymr2