Private Sub MyFunction() End SubBut, why am I forced to use a function in order to return a value:
Private Function GetUrl(ByVal tcUrl As String) As String Dim lcMergedText As String Return lcMergedText End FunctionThis syntax confuses me. I just don't understand why we can't use the Sub approach when returning a value.