listbox populated with Vlookup from multiple worksheet

[DocAElstein]

Hi jay6939
Welcome to ExcelFox
Sorry you’ve got no reply. There are not so many helpers looking in just now at excelfox so it may be a while before someone with UserFrom experience passes by. I don’t have much experience with UserForms, but I did try to have a quick look.
But there seems to ba a problem with the link to your file, both here and at mrexcel.com. It appears to go to a log-in page, or similar, and there are no indications of a share link to the file. This is the link you gave
https://www.dropbox.com/preview/Excel/Part%20tracker%20test.xlsm?role=personal
This is where that link takes you: https://imgur.com/C3ws8vR
Possibly you have given us the wrong link in error? Usually you can get a “share” link to pass on, once you have enabled share for the file at your dropbox account.

You can also upload a file at excelfox. It is not obvious how to do that. Here are some notes on that
https://excelfox.com/forum/showthrea...ll=1#post14273

I have also edited your post for you, since the BB code color tags that you used in your coding messed up those highlighted code lines: You used [COLOR=rgb(184, 49, 47)] , which does not seem to work here. Possibly that was copied from mrexcel where they have a quirky new software. I replaced that with [COLOR=red]
I also wrapped your code in code tags ( https://excelfox.com/forum/showthrea...ll=1#post14274 )


Good luck
Alan

[jay6939]

Thanks for reply DocAElstein.
i have updated link for sample file.
i have tried below Vlookup as well. but system gives me error of no mach type.

UserForm1.lstdatabase1.Column(5, (UserForm1.lstdatabase1.ListCount - 1)) = Application.VLookup(UserForm1.lstdatabase1(.List(.ListIndex, 5), Sheets("Cost").Range("A1:G1000"), 7, False))

thanks