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:


Sub UpdateLabels()

Sheets("Main Screen (Beta)").Label10.Caption = Worksheets("Engine").Range("B1").Text
Sheets("Main Screen (Beta)").Label11.Caption = Worksheets("Engine").Range("B2").Text
Sheets("Main Screen (Beta)").Label13.Caption = Worksheets("Engine").Range("C1").Text

End Sub
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:


Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)

If KeyCode = vbKeyTab Then
TextBox2.Activate
With TextBox2
    .SelStart = 0
    .SelLength = Len(.Text)
End With
End If

Module4.UpdateLabels

End Sub
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