I am using this code to show progress and that the macro isn't hanging
vb Code:
  1. 'Update status bar with message
  2.     Application.StatusBar = "Splitting contents of: " & sFile
  3.     '...
  4.     '...Do stuff (potentially in a loop updating i each time)
  5.     Application.StatusBar = "Updating.." & i
  6.     '...
  7.     '...Do stuff (potentially in a loop updating i each time)
  8.     Application.StatusBar = "Loading.." & i
  9.     '...
  10.     'Give status bar back to Excel
  11.     Application.StatusBar = False

What can I do though if the majority of the work is done in one 'Split' statement at the start?
The macro would still look like it is hanging.
I sort of feel a new thread is needed to be spawned to update the StatusBar until the Split is finished.
Even if that is the way to go, I'm not sure how to do it
Any ideas?