If you wish the procedure return a result, then you need to do it this way either private or public

Code:
Private Function GetNum(Byval Seek As Long) As Long
    '//Do your process here
End Function
Code:
Public Function GetNum(Byval Seek As Long) As Long
    '//Do your process here
End Function
Cheers!