Runtime Error - Subscript out of Range / Object Error

**JHRice** · 05-04-2012, 03:33 PM

Hello, I am trying to set up a UserForm but consistently receive a runtime error or object error. Below is my code:

HTML Code:

I also have a button on the sheet where I want the data to be sent to. The code for it is:

HTML Code:

Also, I am very new to coding (<week).

Any help is greatly appreciated.

**StevenM** · 05-04-2012, 03:49 PM

Where (which line) does the error occur?

**JHRice** · 05-04-2012, 03:53 PM

I spelled Language incorrectly...WOW. Thanks for the response.

**abousetta** · 05-04-2012, 05:08 PM

To prevent this from happening in the future, place Option Explicit at the very top of you code. You would be surprised how often it is a life-saver because it forces you to correct spelling mistakes and declare all the variables correctly.

**StevenM** · 05-04-2012, 05:14 PM

And to have:

Please Login or Register  to view this content.

automatically added to every new module, in the VBE (Visual Basic Editor), go to Tools -> Options and click the "Editor" tab and check the box next to "Require Variable Declarations" (if not checked). Every new module with have "Option Explicit" at the top of the module.