How do I write Functions in Microsoft Visual Basic?

Question

I am having the hardest time writing functions in visual basic. I understand that they DON'T return values as is; but the setting or parameters and ByVal have made me more confused. If possible, please, give an example of some sort.

Answer 1

Functions in VB return values !!

Sintaxis:



Function ( )

=

End Function





Examples:



Function AddValue(Num1 As Integer, num2 As Integer) As Integer

Dim nTot As Integer



nTot = Num1 + num2

AddValue = nTot

End Function



Function AddString(Str1 As String, Str2 As String) As String

AddString = Str1 & Str2

End Function





AddValue() function Acept 2 Integers types parameters "(Num1 As Integer, num2 As Integer)"

AddValue() function Return a Value of Integer type. "As Integer"

(To return a value, just assign the value to return to the function name " AddValue = nTot")





AddString() function Acept 2 Strings types parameters "(Str1 As String, Str2 As String)"

AddString() function Return a Value of String type. "As String"

(To return a value, just assign the value to return to the function name " AddString = Str1 & Str2")

Answer 2

MSDN has some examples ... Give them a try.



Functions *can* and *do* return values - after all,

that is what a function actually does, process an

input to give you an output, i.e.



Function: Input Value ==> process ==> Output



Try not to confuse Functions with Subroutines.





HTH

Answer 3

on your excelsheet, go with the cellular you like the consequence in. After doing this, hint your mouse to the long bar on suitable of the sheet, that feels like an address bar. There you will see an illustration that resembles an 'fx'. click on it, go with your needed function, go with your cells and you're waiting to circulate! take excitement in!