Case inside a Case throws error 424

**Jon.R** · 01-07-2013, 06:52 PM

Hey guys, just a quick question regarding error 424, object required.

I have a module, which upon loading, needs to populate several text boxes, check boxes and drop-down lists based on information in a sheet. Once a row is selected, and the module is chosen, it loads. Well, here is the Initialize info:

Please Login or Register  to view this content.

The problem lies in when I comment out the code below Case "98" the program runs just fine, however when it is uncommented I run into an error 424 and it claims that the module doesn't exist. Perhaps there is a much better way this could be done, but any insight is much appreciated!

Thanks,
Jon

**protonLeah** · 01-07-2013, 08:45 PM

CS is column 97 so the code for column 98 is never executed. Also, column numbers are long integers not strings so the cases should be written
Case 1 not Case "1"
Case 98 not Case "98"

**Jon.R** · 01-08-2013, 12:36 AM

Thanks for the reply pro. Fixed the column numbering to "case x" and extended the column across to column 98. It is still throwing an error 424. I am starting to look into memory issues. But anyone with any insight is greatly appreciated!

**Edit**

OK, I "fixed" the issue with

On Error Resume Next

Anyone with any input greatly appreciated however, Thanks!