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.

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

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.

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.

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.