hi
may be my question is weird . I hope is logical. I have the userform in file DESTENATION .it designed based on file SOURCE . so what I want when I try running the userform from file DESTENATION should open the file SOURCE to populate data in listbox and search based on textbox 1 with column 4 in listbox into file DESTENATION and when close the userform should close the file SOURCE .
note: if you try running the userform for file DESTENATION it will show error becuase there is no data link with it yet.
any idea to achieve this experts ,please?