Optimize long code

[Ignasis]

Hello,

I attach a file with a userform which is working good.

The problem is that I think there is too much code for doing that action, so I would like you to ask if you might know a shortest code with loop or similar.

Main problems:

- Labels are not consecutive
- Cells doesn't have a logic order
- The code only is done until february, if I go on til December it gets soo long.

Hope I explained good,

Thanks!! And merry christmas

[mikerickson]

The first thing I would do is rationalize the names of the controls on the userform.
You could use code like this. Note that this code is to be in a normal module and run at design time. Once all the controls have decent names it can be discarded. The names of the controls will have been permanently changed.

You'll have to change the StartControlName and the Prefix for each row of your grid.
Similar code could take care of the headers and the total row.

Please Login or Register  to view this content.

[mehmetcik]

Please Login or Register  to view this content.

[mikerickson]

I've renamed the controls, added Labels to the Bus and Taxi columns on the user form.

I think that this will do what you want.

Please Login or Register  to view this content.

[Ignasis]

sorry for my late reply,

Thanks mikerickson and mehmetcik! appreciate so much your time and effort.

Both of you solved my problems, I will probably use both of your codes as you opened my mind in other issues.

Again, thanks for your time and have a good christmas