Unfortunately, this is a long-standing problem with ComboBoxes. On
worksheets you can generally fix the problem by adjusting the zoom factor. I
don't know of a solution for UserForms. I would suggest, though, that 97
ActiveX controls on a single UserForm is asking for trouble.

--

Vasant

"Frank" wrote in message
...
I've developed a fairly large workbook in excel that has
about 8 worksheets and about 10 userforms. The largest
userform (about 97 activeX controls on the userform) is
now giving me trouble. Specifically, when I click on
almost any of the combo boxes, I get the following
message in an excel message box: "Not enough system
resources to display completely."

I am working on a Dell Pentium 4, 2.4 mhz machine with
512k ram.

Any help on this issue is greatly appreciated

Frank