How do I change this but of code to show in userform listbox not on a sheet or sheet listbox?
VBA Code:
For Each Cel In rng
For f = 0 To UBound(DirectoryListArray)
cName = LCase(Cel)
fName = LCase(Left(DirectoryListArray(f), Len(Cel)))
If cName = fName Then
Cel.Offset(, 1).ClearContents
Exit For
End If
Next f
Next Cel