Passing Arguments

1 / 3

# Passing Arguments - PowerPoint PPT Presentation

Passing Arguments. There are two ways sub procedures can access external variables: 1. by using module-level variables 2. by passing arguments Example 1: Const PI As Double = 22/7 Sub Main() Dim R as Integer, A as Double

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

## PowerPoint Slideshow about 'Passing Arguments' - wendy-velez

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Passing Arguments
• There are two ways sub procedures can access external variables:
• 1. by using module-level variables
• 2. by passing arguments
• Example 1: Const PI As Double = 22/7
• Sub Main()
• Dim R as Integer, A as Double
• R = Inputbox(“Enter the radius of a circle”,”Input”)
• A = Area(R)
• Range(“A1”).Value = “The Area of the Circle is “ & A
• End Sub
• Private Function Area(R as Integer) As Double
• Area = PI * R^2
• End Sub
• Example 2:
• Sub Main()
• Dim R as Integer, A as Double
• R = Inputbox(“Enter the radius of a circle”,”Input”)
• A = Area(R)
• Range(“A1”).Value = “The Area of the Circle is “ & A
• End Sub
• Private Function Area(R as Integer) As Double
• Const PI As Double = 22/7
• Area = PI * R^2
• End Function
Passing Arguments By Reference and By Value
• Arguments passed by Reference is the default method and passes a reference to the variable being passed.
• When variables are passed by Reference, the original value of the variable can be changed permanently.
• When variables are passed by Value only a copy of the original variable’s contents are available to the calling procedure.
• Arrays are passed to procedures (Sub or Function) by Reference since the elements are generally manipulated. The physical address in memory cannot be changed and passed by Value.
• Function subroutines always return either a value, Boolean, or string result.A = Area(R) is an example of invoking a Function. The variable A will also receive the result passed from Area.
Concatenating Names And Random Numbers
• You can concatenate names two ways:
• 1. You can use the + sign, “Joe ” + “College”
• 2. You can use the & symbol, “Joe “ & “College”
• The second rendition is the preferred style.
• Random numbers are generated using the function Rnd. You can use Int function to retrieve the integer portion generated. The actual function generates numbers between 0 and 1.
• The function Randomize is a seed function that assures the numbers generated each time are random.
• Example: number = 1 + Int (Rnd * 100) will generate numbers between 1 and 100.