asked on

Excel 2010: Getting Run-time Error

Hi Experts!

I have some code that I'm using to create a checkoff list with. The code was working great until I adjusted the control buttons at the top. Basically all i did was space them out more evenly and made the timer box bigger. In doing this I had to delete the first text box and it's checkbox at the top of the form to make room for the adjustment. Once complete, I went to launch the macro, It's giving me a run-time error now. Would one of you .vba guru's take a look at this to see where I'm going wrong at and what I need to do to correct it? Attached is the run-time error itself along with the debug item that it's choking on within the form code. Thanks a million for your help!

Bill Prew

Seems like you deleted one of the 50 textbox'es it was moving data into. If you want to show less, then you should delete the one named "50" on the end, and then change this loop to be to 49 not 50. There may be other places in the code this matters too, having one lest textbox.

»bp

Bill Prew

Although looking at the loop right above that, perhaps you deleted one of the 1 - 20 textboxes, since the loop above worked for 21 - 50.

Can you post the file here?

»bp

itsmevic

ASKER

Here is the file.
Copy-of-Desktop-Widget-Checkoff-Lis.xlsm

SOLUTION

Bill Prew

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

itsmevic

ASKER

We could do that, not a problem. If we can write an exception that would be great. Also, the limit of text fields is at 50, curious if we could bump that up to say 65 fields instead?

SOLUTION