In the previous article, we learned about subroutines. You will learn about VB 6 functions in this article and learn the difference between a function and a subroutine.
A Vb 6 subroutine receives an argument but does not return anything. However, a function takes an argument and returns a value. A VB 6 function is a block of code that can separate your program into manageable parts.
Declaring a VB 6 Function
[Private | Public | Friend] [Static] Function name [(arglist)] [As type] ... [Statements] ... [expression] ... [Exit Function] ... [Statement] ... End Function
- Public keyword – All procedures in all other modules and forms can access the function.
- Private keyword – All procedures and function in the same module or form where the function is declared can access it.
- Friend keyword – Used only in modules that uses classes and it means that all procedures throughout the project can access this function except the controller of an instance of an object.
- Static – Normally, a local variable to a function get destroyed when function terminates. Static keyword keeps the value of a local variable intact between function calls.
- Function name – User-defined name for the function.
- arglist – A list of variables passed as arguments to the function.
- type – The return data type of the function.
- Statements – A group of statements that a function can execute.
- Exit Function – A way to exit the function immediately before it could complete execution.
- End Function – Terminates the function upon completion.
How to declare arglist in the function?
Arguments to a function are values that the function will use to complete a calculation or complete a task.
To call a function you have to use the function name and the list of arguments which uses the following syntax.
[Optional][ByVal|ByRef][ParamArray] varname[()] [As type][= defaultvalue]
Now, we will briefly discuss the list above.
Optional – This keyword means that the arglist is optional and not required.
ByRef – This keyword means that a reference to the original value is passed through the function.This is true by default.
ByVal – This keyword means that the original value of the variable is passed to the function.
ParamArray – Usually you can send limited number of variables through a function, however, if you need to send a list of values of same type use the ParamArray or nothing at all, because this is optional.
varname – It is the programmer-defined name of the argument.
type – This defines the data type of the argument.
defaultvalue – If you want to set a optional default value for a argument, this feature is helpful. If no value is supplied for a variable, then the function can use the default value for computation.
Example Program: VB Function
In this example, we will create a simple function that accepts two numbers and return their
Private Sub Command1_Click() Dim result As Integer result = Sum(5, 23) MsgBox ("Result = " + Str(result)) End Sub Function Sum(number1 As Integer, number2 As Integer) As Integer Sum = number1 + number2 End Function
Visual Basic 6.0 Programming by Examples Kindle Edition
Visual Basic is one of the easiest to learn computer programming language.
Yes, it is obsolete, but all MS Office products include VBA (Visual Basic for Application) and if you learn VB, you will know VBA!
In my tutorial, I used VB 6 to explain step by step how to create a simple Visual Basic Application and a relatively complex one (a Patient Management system) that is using a database. A patient Management application source code is explained in detail.
You will learn how to design and create a database in MS Access and how to create tables and queries.
The book includes a sample application that shows how to use Windows API function.
You will learn how to convert VB program that can be run only in Visual Basic development environment to a distributable application that can be installed on any client computer.
For illustration, I included 128 screenshot images and links to a video.
You will be able to download from my website complete source code for 7 Visual Basic projects including a Password Keeper, a Patient Management and a Billing Management application.
Get Your Copy Today!