"VBA Error - "invalid use of Me Keyword"

[Johnny C]

I've got a userform which monitors progress of some VBA.

In a sub called by the userform.activate event, there are a load of Me.<> statements which update things on the userform.

it was working fine but I've made a lot of changes - nothing to do with the userform, just processing changes, and haven't run the macro for a few weeks.

Now I've jsut started it for final testing, and it falls over on compile with the following error:

"Invalid use of Me Keyword"
The line it's falling over on (which was fine before) is

    Me.lblCurrentStatus.Caption = "Initialising - clearing old data"

The error help isn't much use, it's just about using Me in class modules, not ordinary modules, and as I say it was working fine before.

Can anyone shed light on this?

TIA

 

[Fluff]

How about

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
   
   Dim cel As Range
   Dim j As String
   Dim i As Integer
   
   i = 0
   For Each cel In ActiveSheet.Range("B9,B14:B16")
      If IsEmpty(cel) Then
         i = i + 1
         j = j & cel.Address & vbNewLine
      End If
   Next cel
   
   If i <> 0 Then
      MsgBox "Seriously, Dave? Fill in the box. "
      Exit Sub
   End If
   
   i = 0
   For Each cel In ActiveSheet.Range("F16,B17")
      If IsEmpty(cel) Then
         i = i + 1
         j = j & cel.Address & vbNewLine
      End If
   Next cel
   
   If i <> 0 Then MsgBox "OMG! Fill in the box. "
End Sub