Code crashes automation error help

[intex]

Hi guys,
I'm only learning vba so maybe somebody can have a look at the code and give me some advice what can be wrong?
this code was working fine, but suddenly it start crashing, basically what happens:
When i press the "btnlookup" button excel crashes saying "automation error exception occurred".
When i tryied to step into the code pressing F8 it keeps stopping at the line which i highlighted and goes back to the one i highlighted in green.

I appreciate all help, thanks in advance

Please Login or Register  to view this content.

[Norie]

Do you definitely have 125 textboxes named textbox1, textbox2, textbox3... textbox125?

[intex]

Hi Norie,
yes this is part of my userform, basically this is very big userform which will be used at work as a database.

[Norie]

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

[intex]

Norie,

The file is 3.7mb and it is too large to upload, maybe there is another way how can i upload it to you?

[Norie]

Can you create a cut down he version without minimum data?

If you can't you could try zipping the file and uploading the zipped file.

[intex]

Norie,
i have uploaded the zip file. Thanks for your help

[Norie]

I've only just had a quick look at the workbook but I really don't think you should be using a userform for this, especially not a userform with so many controls.

Couldn't you have a simple userform that's displayed when the user double clicks on a cell in a row and then allows them to enter data on that row?

[Norie]

Oh, forgot to mention - how can I replicate the problem you are having?

Is there a particular button I need to press, perhaps some data I should enter etc...

[intex]

After you open file open userform then enter 123456 into textbox "txtOrder" and then press black button "btnlookup".
I noticed it works fine if after opening the file you will go to developers tab and enter visual basic and then close visual basic, but if you will go straight to userform and do everything what is mentioned above it will crash.

Thanks Norie