I just saw this posted by @RubberduckVBA on Twitter and couldn’t resist sharing it on here. Did you know that this VBA code will compile and run correctly?
Public Property Get Foo() As String Foo = "WTF!" End Function
And, perhaps even scarier, so will these (and variations thereof):
Public Property Get Foo2() As String Foo2 = "WTF!" End Sub
Public Property Get Foo3() As String Foo3 = "WTF!" Exit Function Exit Sub End Property