View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Lee Lee is offline
external usenet poster
 
Posts: 8
Default 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