https://bugs.documentfoundation.org/show_bug.cgi?id=161883
--- Comment #1 from Rafael Lima <rafael.palma.l...@gmail.com> --- I guess the CC sub is working as expected. Maybe you placed the MsgBox in the wrong place (when compared to CC1). Below is your code with proper indentation: Function CC(lNumber As Long) As String Dim s1 As String If lNumber <= 0 Then s1 = "lNumber <= 0" Else If lNumber > 1 Then s1 = "lNumber > 1" Else s1 = "Else" End If MsgBox s1 CC = s1 End If End Function So if you call CC(0) it will never reach the MsgBox nor will it set any return value. -- You are receiving this mail because: You are the assignee for the bug.