Hi All,
I don't usually have to post on forums for help with excel related problems but I am well and truly beaten with this issue!
Excel will hang up as if it's gone into a continuous loop (Although no looping macros are active) when you open or close a user form. The task bar in Excel will flash Ready Calculate. Visual basic reports no code is running but excel either crashes or becomes very unresponsive. I have to exit and reopen excel in order to fix the problem - very annoying.
It also doesn't happen at any one specific point it can vary.
I have various VLOOKUPs around the workbook that help my userforms display the correct information. I use the INDEX formula in the control source of textboxes. I also use the offset formula to make sure DTPICKER displays correctly.
I am using 'Option Explicit' at the start of all my code.
I have tried a 3rd party code cleaner.
No visual Basic references are MISSING
I have tried to cover all the bases here I hope someone can assist.
Matt
I don't usually have to post on forums for help with excel related problems but I am well and truly beaten with this issue!
Excel will hang up as if it's gone into a continuous loop (Although no looping macros are active) when you open or close a user form. The task bar in Excel will flash Ready Calculate. Visual basic reports no code is running but excel either crashes or becomes very unresponsive. I have to exit and reopen excel in order to fix the problem - very annoying.
It also doesn't happen at any one specific point it can vary.
I have various VLOOKUPs around the workbook that help my userforms display the correct information. I use the INDEX formula in the control source of textboxes. I also use the offset formula to make sure DTPICKER displays correctly.
I am using 'Option Explicit' at the start of all my code.
I have tried a 3rd party code cleaner.
No visual Basic references are MISSING
I have tried to cover all the bases here I hope someone can assist.
Matt
