I've created a VB search form that opens automatically when you run a spreadsheet that contains about 5000 contact centre call comments (problem and advice given). This works fine. What I now want to do is create a splash screen to come up while the excel sheet is loading in the background. Due to the amount of info in the spreadsheet (it's about 3mb), it takes a good 25-30secs to load.
I understand how to put a splash screen in via
And then add in all the relevant code regarding the length of time it should be open etc.
But this comes up AFTER the workbook has loaded. What I want is the splash screen to come up first and the workbook to load behind it.