Userform problem - runtime error could not find the specified object

[PATSYS]

Hi all,

I have the below code in my module:

Sub Uform1()
UserForm1.Show
End Sub

When I run it I keep getting error message:

RUN-TIME ERROR '-2147352573 (80020003)':
COULD NOT FIND THE SPECIFIED OBJECT.

In the same workbook, I have a userform with name UserForm1, so I am not sure why it could not find it.

Pls help.

Thanks

 

[Colin Legg]

Hi,

Was this code working previously and has now started to error?


Try uninstalling and reinstalling your add-ins.

In fact, if you would be kind enough to do them one at a time and re-test your code each time, it would be very useful to know if the suggestion works, which particular add-in reinstall fixed the issue.

HTH

 

[PATSYS]

Hi Collin,

Yes it was running a while ago. Then I tried to change something on the userform (I inserted a new image). Ater that I got the error.

There is no addin. I just have a button that is assigned with the SUB UFORM1

Thanks

 

[Colin Legg]

Not an add-in specific to the project. The general Excel add-ins you have installed.

In the main Excel interface go to Tools | Add-Ins.
All the ticked add-ins in there are installed.

If you could uninstall + reinstall each add-in one at a time and re-test your code each time, I think there's a good chance it will fix the issue. I'm asking to test as you reset each add-in because it would be good to know which add-in caused the problem. I don't know why it fixes the problem, and I've never experienced the problem, but it has fixed the problem for other users in the past:
http://www.mrexcel.com/forum/showthread.php?t=379679

It would be good to know which add-in is the culprit so we can speculate why it might have caused the problem in the first place.


Thanks

 

[PATSYS]

Hi Collin,

None of those excel built-in addin were ticked before or after I got the error.

I was actually able to fix the problem by exporting the userform and the module to my harddrive, open a totally new file and impot the userform and the module.

Not sure how but now it works..

Thanks

 

[danm1130]

In case others are having this issue and found this old thread like I did: I got this same error, and excel helpfully brought me to the Show command for the userform, but the error was actually in the initialize code on the form itself, the object in question being a non-existent object on the form, not the form itself.

Hope that makes sense/is helpful.