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
Bookmarks