error 424 'Object required'

K

kekava

Just wanted to share my experience and save someone banging their heads

A simple "UserForm1.Show" appeared to generate the above error, i.e., debugger highlighted the "UserForm1.Show" line which made me think this line was the problem

The true reason was: loading the form triggered (by my own design) some operations (like disabling) with form controls, some of which I had deleted or renamed in my previous editing session. Object missing but required were those controls, not the form as first seemed to be the case

My advice: look at what your script is doing after the form is loaded! The problem may be there.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top