UserForm to View and Edit data in a closed workbook

Hi Everyone,

I would like the form i created to find data from a different workbook, then if needed i will be able to change the data in the other workbook.

I failing at the first hurdle, getting the information to show in the userform!

My initial thought (as seen in the Search.xlsm Document) is to have the vba open the document then close it once it has retrieved the search, is this best practice or is there another way to do this?

Ive tried myself to get it working however it wont do it and i get an error so i must be missing something somewhere so i would greatly apreciate your help.

Capture.PNG

im also confused on how i would get the check box to check if cell = "Y"

TIA