Cannot create forms?

C

cht13er

Howdy. I am working with VB in Excel 2000, and am trying to call up a
User Form when something happens in my code (in VB).

However, when I am in VB, and go "Insert">"UserForm", and then open up
the UserForm, I can see the grey userform, I can change the properties
of it, but I can't place anything on it - no lists, no textboxes, no
commandbuttons.. I just get the message "Not enough storage is
available to complete this operation."

The size of the excel file is 330kb, I have 2MB free space on my
hard-drive, and if I backup my code (the module) it's 10kb. And if I
ctrl-alt-del and go to my windows task manager, I am seeing about 20%
of my memory being used.

Any help that you can provide would be excellent. Thanks!
 
K

Kari J Keinonen

Hello!

First
Clean you harddisk. Delete all unnecessary files your hard-drive, there must
be free spaces over 10 %. (IE tempfiles, page history and your own
Temp-folders files etc.)
Second
Defragment your harddisk.

Regards,
Kari J Keinonen
 
D

Dave Peterson

Just a guess...

close excel (and all other programs that are running)
windows start button|Run
%temp%
and hit enter

Delete as much as you can.

Excel uses the windows temporary folder and when that gets too cluttered, bad
things can happen. Maybe you'll get lucky and this'll fix it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top