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