Call Sub Procedure From User Definded Function

[BillBrosius]

Can you call a Sub Procedure from within a User Defined Function?

Function AddThis(var1,var2)
Call dothemath
End Function

Sub Procedure dothemath(f_var1,f_var2)
final_result = f_var1 + f_var2
Msgbox(final_reslut)
End Sub

Obviously this is a very simple example, but can it be done?

Thanks.

Bill

 

[vb5prgrmr]

Yes, But ...
[tt]
Function AddThis(var1,var2)
Call dothemath(var1, var2)
End Function

Sub Procedure dothemath(f_var1,f_var2)
final_result = f_var1 + f_var2
Msgbox(final_reslut)
End Sub
[/tt]
In bold will need to be added for it to work and not throw an error.

Good Luck