VBA Userform does not work with closed workbook

[Richard]

I am using the (2) Two workbook setup


#1 Data workbook (Active Workbook)

#2 Macro workbook (Hidden)


When the Macro WB is open the ListBox works, it is slow on the Scroll, I have 42,000 items to lookup, but when the Macro WB is closed the ListBox is Empty.


I can not leave the Macro WB open because the Active WB function does not work.


If i move the Data to the Activeworkbook the file goes from 752kb to over 2,000kb.


I prefer to have the Data in the Macro WB (to keep the Active WB small) as the Active WB will be saved over 600 times to a web SharePoint program.

 

[Luke M]

Could you post some of the code that you are using? My initial guess is that you might be able to solve some of your problems by removing ambiguous "ActiveWorkbook" objects and replacing them with "ThisWorkbook" objects.