Passing arguments
Download
1 / 3

Passing Arguments - PowerPoint PPT Presentation


  • 93 Views
  • Uploaded on

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

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

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
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
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
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.


ad