VBA - Userform won't start but gives and error "run-time error '424"

Hi Guys,

I'm getting very fustrated, i have a code that used to work and i haven't really done anything to the code.
My office crashed before this happend.

kindly help

Untitled.png
LVL 1
HakumAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David SankovskySenior SysAdminCommented:
Could you have possibly changed the name of the form?

The error code basically claims that the object it's looking for isn't there.

i have a code that used to work and i haven't really done anything to the code.

There's a VERY fine line between not changing AT ALL and not really changing anything.

If there were any changes, what were they? Did the office crash while making those changes? can there be some unsaved changes that are required for that to work?
0
HakumAuthor Commented:
I havn't changed the name as you can see in the screenshot, i have even tried to rename it but no luck..

I was working in vba editing some lines in the Userform when office crashed but nothing else then that.
0
David SankovskySenior SysAdminCommented:
Then We might need to have a look at the code of the Form itself.

The error might be thrown by the userform but displayed by the main window as a return function,

Do you have a backup of the original code before you made any changes?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Roy CoxGroup Finance ManagerCommented:
Was there a calendar form datepicker or similar on the UserForm?

Have you recently updated Office?
0
HakumAuthor Commented:
yes there was and yes it has recently been updated!

is there a bug here? or do i need to update a reference to an object?
0
GrahamSkanRetiredCommented:
Do you have any code in the UserForm_Initialize event?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Roy CoxGroup Finance ManagerCommented:
I would think that thet your version no longer has the Calendar Control available. The UserForm should open but without the Calendar control. If not open the VB EDitor and check if you can delete that control. I have some none activeX calendar examples but they are in Excel. You should be able to create similar in Word
0
Roy CoxGroup Finance ManagerCommented:
I've migrated my UserForm   calendar to Word.  I need to get it to write to the document now so I'll need to research that because I don't use Word VBA very often. I can't upload it here for some reason but here's a link to the file in DropBox. I'll update it as soon as I can.

Calendar Example
0
NorieVBA ExpertCommented:
Can you post the code in the userform Initialize/Activate event and/or attach a sample document?
0
byundtCommented:
When debugging userforms, you will frequently get an error indicated at the .Show statement when it actually occurs elsewhere. Try hitting F8 to step through your code. You can then tell exactly which statement is throwing the error.
1
Roy CoxGroup Finance ManagerCommented:
The illustrated error usually occurs when a control on the userform is not available in the current version of EXcel
0
NorieVBA ExpertCommented:
Roy

The reported error is commonly caused by problems in the code of the Activate/Initialize event of a userform.

So to diagnose the error it would be handy to see that code, if there is any.:)
0
HakumAuthor Commented:
Thank you guys! I foudn the error but runnign through the code again! and actually finding the the error was in the "Userform_Initialize" part.....

thank you so much!!!! really nice to have some1 to spare with specially when you are still learning :D
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Word

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.