The following code for a user form was developed in Excel 2000 and works fine there but does not work in XP. I get a runtime error with the red code hi-lited by the debugger. Can anyone tell me why?
Rich (BB code):
Private Sub lblDailyMessage1_Click()
End Sub
Private Sub lblDateTime_Click()
End Sub
Private Sub lblScripture_Click()
End Sub
Private Sub lbltopic_Click()
End Sub
Private Sub OKButton_Click()
Unload Me
End Sub
Private Sub UserForm_Activate()
Dim Quote1 As String
Dim Quote2 As String
lblDateTime.Caption = Format(Now, "dddddd, h:mm am/pm")
Quote1 = Worksheets("Daily Messages").Range("B2")
lblscripture.Caption = Quote1
Quote2 = Worksheets("Daily Messages").Range("D2")
lbltopic.Caption = Quote2
End Sub