PC runs slow whenever workbook with UserForm is open
 

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.

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

PC runs slow whenever workbook with UserForm is open
 

I have used userform many many times. I never noticed a slowdown.

Try cleaning out your temp directory and any subdirectories of the temp
directory while Excel is closed.

--
Regards,
Tom Ogilvy


"dread" wrote in message
...
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.

PC runs slow whenever workbook with UserForm is open
 

I read another post similar to this. The guy ended up finding a pile of
hidden forms under what he thought was 1 form. I think it was around 60 or
so. Just a thought.

Alan



"dread" wrote in message
...
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.

PC runs slow whenever workbook with UserForm is open
 

That sounds more like shapes on a worksheet.

--
Regards,
Tom Ogilvy

"Alan" wrote in message
...
I read another post similar to this. The guy ended up finding a pile of
hidden forms under what he thought was 1 form. I think it was around 60 or
so. Just a thought.

Alan



"dread" wrote in message
...
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.