RawlinsCross
Active Member
- Joined
- Sep 9, 2016
- Messages
- 437
Hi there,
I have a spreadsheet that loads in a fair bit of data - takes a couple minutes. During this time, I'd like to put a userform 'sign' on the screen that says "Data is Loading, keep your grubby hands away from the computer", or something to that effect
Anyhow, I can't seem to get it to work. I have other code in the:
but this seems to run after the calculation is complete. How do I put up a "hold your horses" userform for the length of time it takes for excel to finish its thing.
Cheers,
John
I have a spreadsheet that loads in a fair bit of data - takes a couple minutes. During this time, I'd like to put a userform 'sign' on the screen that says "Data is Loading, keep your grubby hands away from the computer", or something to that effect
Anyhow, I can't seem to get it to work. I have other code in the:
Code:
Private Sub Workbook_SheetCalculate (ByVal sh As Object)
but this seems to run after the calculation is complete. How do I put up a "hold your horses" userform for the length of time it takes for excel to finish its thing.
Cheers,
John