Vba
Web Scraping with VBA
What is Data Scraping? Data scraping is the technique that helps in the extraction of desired...
A function is a piece of code that performs a specific task and returns a result. Functions are mostly used to carry out repetitive tasks such as formatting data for output, performing calculations, etc.
Suppose you are developing a program that calculates interest on a loan. You can create a function that accepts the loan amount and the payback period. The function can then use the loan amount and payback period to calculate the interest and return the value.
Why use functions
The advantages of using functions are the same as the ones in the above section on why use subroutines.
Rules of naming functions
The rules for naming functions as the same as the ones in the above section on rules for naming subroutines.
Private Function myFunction (ByVal arg1 As Integer, ByVal arg2 As Integer) myFunction = arg1 + arg2 End Function
HERE in the syntax,
Code | Action |
---|---|
|
|
|
|
|
|
|
|
Function demonstrated with Example:
Functions are very similar to the subroutine. The major difference between a subroutine and a function is that the function returns a value when it is called. While a subroutine does not return a value, when it is called. Let's say you want to add two numbers. You can create a function that accepts two numbers and returns the sum of the numbers.
Step 1) User interface
Add a command button to the worksheet as shown below
Set the following properties of CommanButton1 to the following.
S/N | Control | Property | Value |
---|---|---|---|
1 | CommandButton1 | Name | btnAddNumbers |
2 | Caption | Add Numbers Function |
Your interface should now appear as follows
Step 2) Function code.
Private Function addNumbers(ByVal firstNumber As Integer, ByVal secondNumber As Integer) addNumbers = firstNumber + secondNumber End Function
HERE in the code,
Code | Action |
---|---|
|
|
|
|
|
|
Step 3) Write Code that calls the function
Private Sub btnAddNumbersFunction_Click() MsgBox addNumbers(2, 3) End Sub
HERE in the code,
Code | Action |
---|---|
"MsgBox addNumbers(2,3)" |
|
Step 4) Run the program, you will get the following results
Download Excel containing above code
Summary:
What is Data Scraping? Data scraping is the technique that helps in the extraction of desired...
$20.20 $9.99 for today 4.6 (119 ratings) Key Highlights of VBA Tutorial PDF 85+ pages eBook...
Download PDF 1) Explain what is VBA or Visual Basic for Applications? VBA stands for Visual Basic...
Creating VBA Form/GUI controls in Excel GUI is the acronym for Graphical User Interface. The GUI...
This Excel VBA tutorial for beginners covers in-depth lessons to learn VBA Excel and VBA basics....
VBA String Operators String data is used to hold data that is made up of numbers, characters, and...