Userform Freezing

pace

New Member
Joined
Feb 25, 2002
Messages
28
I have a userform with about 8 comboboxes and four option buttons, about three quarters the way through the form freezes and you end up having to do a reboot.
It doesn't matter if you start at the bottom of the form and work your way up (rather than down) it still freezes, ie it's not related to a particular combobox.
I have copied all the boxes onto a new form with the same problem occuring.
Also there's very little code behind the form and I have tried it on four different computers....still no luck.

Help anyone????!!!
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Pace,

I used to have the same sort of problem. It was all fixed with another 256M Ram.

Possible?

Burger
 
Upvote 0
Can you give some more details. Is this form used in an Excel macro? You say there is little code but perhaps you could post the code otr some of it.

I suppose it is possible that RAm may be insufficient but it seems unlikely to me - do you knwo roughly the specs of the PCs if they are new or less than year old they should have specs to handle such a form.

Maybe your code is creatign some loop or inefficient use of memory.
 
Upvote 0

Forum statistics

Threads
1,214,878
Messages
6,122,062
Members
449,064
Latest member
scottdog129

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top