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...
I am using a (2) Two file system
1 file holds the Macros (Hidden Workbook)
1 file holds the Form (Initial File Name as the ActiveWorkbook)
The Form alows the user to enter
the Administrator,
the Account# and then to choose
the Agreement that they want to work on.
When they choose an...