VBA Combobox broke

[Sumpie]

Hi,

So after working for couple of weeks my macro suddenly stopped working and keeps giving me a compile error.
I also cannot create any new activex items anymore in my excel files.

I heard there were an update on VBA? But I dont believe that would cause an issue like this?

Is there also maybe a possiblity that my IT department made some changes that causes this?

 

[KOKOSEK]

Can you translate this error message into English, please.
Also put VBA code and tell which line generate this error (highlight in yellow).

 

[RoryA]

Activex controls on worksheets are notorious for this. You need to close Office and delete any .exd files on your hard drive then try it again (.exd files are temporary files created when you use activex controls and if the temp version is not the same as the current version of the relevant library - usually the fm20.dll - then you will have the issue you are describing).

 

[Sumpie]

Can you translate this error message into English, please.
Also put VBA code and tell which line generate this error (highlight in yellow).

It says
Compile Error:
Method or data member not found.

I think the error occured because of the copy worksheet macro that I made.
It seems that on the original page (the sheet i want copied x times) everything works fine.
Since I need a quick fix im just gonna copy it 53 times but i have to look into why the error occurs, if anyone has any pointers let me know.