Thread: Run-time error '424'

Seriously need some help. I got this error two weeks ago and can't figure out why or how to get rid of it. Is there somewhere like a log that I can figure out where this is coming from?

I am working with a multipage userform that is basically complete. I "beleive" the error happened when I tried to "link" one of the textbox on the userform to the worksheet the user would input there data onto. However, when I deleted that function, the run-time error persists.

Please help! I do not want to have to redo 3 days worth of work to rebuild this userform!

This is an "object required" error - you have a function or command and have not entered the correct number of objects into the argument.

To look these up go into Help (F1) and type in trappable errors. You'll find this under help for Visual Basic, not under the general Excel help.

Originally Posted by tarquinious

This is an "object required" error - you have a function or command and have not entered the correct number of objects into the argument.

To look these up go into Help (F1) and type in trappable errors. You'll find this under help for Visual Basic, not under the general Excel help.

Yes, that is the help that I have seen already but to me, it makes no sense. Sorry, I just beyond frustrated.

You may have to attach a sample of your spreadsheet that is giving you this error. My guess is either:
1. If you are getting this error when entering data into a worksheet, than there is a function being triggered which is expecting more variables. Somewhere you may have a function being called e.g. =MyFunction(var1, var2, varx) but somehow only 2 of the 3 variables are being passed to it.

2. If you are getting this error when running a macro of your own, you have a command in there that is expecting more variables than you have entered. e.g. call MySubroutine(length, girth) - but MySubroutine expects 3 variables to be passed to it.

My guess is the latter where you have written a command or called a function or routine which expects more (or possibly less) bit of data to be passed to it.

Step through your code (F8) and see which line is giving you the grief, then check out the Help on that function to see what variables are compulsory.