UserForm is frozen

**berlini** · 08-17-2011, 06:45 PM

Hey Guys,

I ve been working all day long on my UserForm and it worked fine, then I launched it again and I only get the form but I cannot use it! It´s frozen. I cannot even close it, I have to open the windows task Manager and then close the file from there.

Please help me! What could be the reason?

Thanks

**davesexcel** · 08-17-2011, 07:29 PM

What code do you have in ther userform?

**berlini** · 08-17-2011, 07:36 PM

Hello Davesexcel Thanks for your help!
This is the code:

Please Login or Register  to view this content.

Can I send you the file by Personal Message, so that you can see that the form is not responding?

**davesexcel** · 08-17-2011, 07:45 PM

You can attach a simple sample workbook to your post. Click the paperclip to upload a file.
Keep it very simple, we just need to see where the error occurs.

Have you tried Ctrl+break to see if this stops the code?

**berlini** · 08-17-2011, 07:49 PM

Here´s the file!
what I wanted to do (an actually achieved to do) is click on the button on the worksheet, the userform appears with the last entered data, when an entry is changed it should be transfered to specified cells of the worksheet.
But suddenly the Form didn´t respond anymore...
You can see that Book2 works pretty good but it´s uncomplete compared to book 2_2

Thanks Davesexcel, i really in trouble, I have to deliver tomorrow!