Can't add new controls to userform. Run-time error '-2147352573 (80020003)'

João Sequeira

Board Regular
Joined
Jun 29, 2015
Messages
93
Hello all,

First off I'm really new to excel and vba so bare with me
clear.png

I've always been able to solve whatever problems I encounter, searching forum and melting my brain, but this one is way out of my reach and I don't seem to find nothing in the forums that clearly solves the problem.

I'm constructing a series of dependent userforms and everything was going fine until this specific userform and I cant understand what i'm doing wrong.

The problem (step by step):
In VBA
1. insert userform frmINS_FORNECEDORES
2. insert text boxes, combo boxes, command buttons and labels
3. name all the controls
4. add code to one or more controls
5. run the code <----- Error "Run-time error '-2147352573 (80020003)' Could not find the specified object."
6. go back to the user form and find that all controls have disappeared except combo boxes

What I've tried:
- Deleting the userform and inserting a new one from scratch. same error
- Exporting all the userforms (except the "infected one") and sheets to a new file. inserting a new userform. same error

Please help.

Thanks,
João

Update:
´
It seems I cant add any new controls to any of the userforms. Futhermore if I delete a label, or a command box from any of the other stable and finished forms and add a new one the error persists.

I am going nuts
clear.png
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
SOLVED!


Sometime ago I messed with the toolbox and I switched some of the controls with what I thought to be the same that were there in the first place... They weren't!


Restored controls work just fine.


Newbie mistake I'm sure.


Sorry for the wasted bytes :)
 
Upvote 0

Forum statistics

Threads
1,214,985
Messages
6,122,605
Members
449,089
Latest member
Motoracer88

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top