PC runs slow whenever workbook with UserForm is open
On Feb 2, 5:21 pm, dread wrote:
My pc seems to run very slow whenever I open the workbook that has the
UserForm that I'm creating (first time I've ever used UserForm). Any ideas
on why and how to fix the problem?
Thanks in advance.
Without more detail, it is hard to say for sure, but make sure you are
turning off calculation when you open your userform and turn it back
off when you unload the form.
Application.Calculation = xlCalculationManual
'Your Code Here
Application.Calculation = xlCalculationAutomatic
|