passing arguments n.
Download
Skip this Video
Download Presentation
Passing Arguments

Loading in 2 Seconds...

play fullscreen
1 / 3

Passing Arguments - PowerPoint PPT Presentation


  • 94 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


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