Macro Module Won't Run All Lines in Excel 2007

[hazza147]

Hi,

I have created a rather simple Module which updates TextBox style Labels with values from a seperate Sheet named Engine. It works like a dream in Excel 2003 however when I take it to Excel 2007 it works in some areas however in the most essential one, to update after a particular text box has data in it doesn't.

The code can be viewed below:

Please Login or Register  to view this content.

This module is called Module 4 and I run it at the end of a macro's on the Main Screen (Beta) sheet like so:

Please Login or Register  to view this content.

I'm trying to work out if there was a way I could improve the way Module 4 (top) works. Like I say the whole spreadsheet works fine in 2003 however when I try it on a Excel 2007 sheet it only updates Label10 i.e. only runs the top line of the Module.

Is there anything extra I can do to make sure 2007 runs all 3 lines?

Many thanks for your help.

Kind Regards,
Harry Seager

[davesexcel]

Have you tried the code in textbox exit?

[hazza147]

Have you tried the code in textbox exit?

Hi Dave,

Don't quite understand what you mean?

Cheers,
Harry

[davesexcel]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[hazza147]

Hi Dave,

The thing is my spreadsheet works perfectly fine in 2003 however in 2007 whenever I key down through my textboxes it doesn't run the whole of Module 4, only the 1st line. Posting a dummy spreadsheet will take a long long time as there is so many textboxes and data etc.

Cheers,
Harry