Introduction

If you create a procedure that takes one or more arguments, whenever you call that procedure, you must provide a value for the argument(s). Otherwise,, you would receive an error. If such an argument is passed with the same value over and over again, you may be tempted to remove the argument altogether.

In some cases, although a certain argument is passed with the same value most of the time, you still have situations in which you want the user to decide whether to pass a value or not for the argument, you can declare the value optional. In other words, you can create the argument with a default value so that the user can call the procedure without passing a value for the argument, thus passing a value only when necessary. Such an argument is called default or optional.

Imagine you write a procedure that will be used to calculate the final price of an item after discount. The procedure would need the discount rate in order to perform the calculation. Such a procedure could look like this:

Function CalculateNetPrice#(ByVal DiscountRate As Double)
    Dim OrigPrice#

    OrigPrice = InputBox("Please enter the original price:")

    Return OrigPrice - (OrigPrice * DiscountRate / 100)
End Function

Since this procedure expects an argument, if you do not supply it, the following program would not compile:

Public Module Exercise

    Function CalculateNetPrice#(ByVal DiscountRate As Double)
        Dim OrigPrice#

        OrigPrice = InputBox("Please enter the original price:")

        Return OrigPrice - (OrigPrice * DiscountRate / 100)
    End Function

    Public Function Main() As Integer
        Dim FinalPrice#
        Dim Discount# = 15 ' That is 25% = 25

        FinalPrice = CalculateNetPrice(Discount)

        MsgBox("Final Price = " & FinalPrice)
        Return 0
    End Function

End Module

Here is an example of running the program:

Optional Argument

Optional Argument

Most of the time, a procedure such as ours would use the same discount rate over and over again. Therefore, instead of supplying an argument all the time, you can define an argument whose value would be used whenever the function is not provided with the argument.

Passing an Optional Argument

To specify that an argument is optional, when creating its procedure, type the Optional keyword to the left of the argument's name and assign it the default value. Here is an example:

Public Module Exercise

    Function CalculateNetPrice#(Optional ByVal DiscountRate As Double = 20)
        Dim OrigPrice#

        OrigPrice = InputBox("Please enter the original price:")

        Return OrigPrice - (OrigPrice * DiscountRate / 100)
    End Function

    Public Function Main() As Integer
        Dim FinalPrice#
        Dim Discount# = 15 ' That is 25% = 25

        FinalPrice = CalculateNetPrice()

        MsgBox("Final Price = " & FinalPrice)
        Return 0
    End Function

End Module

Here is an example of running the program:

Optional Argument

Optional Argument

 
 
 

A Procedure With Many Optional Arguments

If a procedure takes more than one argument, you can provide a default argument for each and select which ones would have default values. If you want all arguments to have default values, when defining the procedure , provide the Optional keyword for each and assign it the desired default value. Here is an example:

Public Module Exercise

    Function CalculateNetPrice#(Optional ByVal Tax As Double = 5.75, _
                                Optional ByVal Discount As Double = 25, _
                                Optional ByVal OrigPrice As Double = 245.55)
        Dim DiscountValue As Double = OrigPrice * Discount / 100
        Dim TaxValue As Double = Tax / 100
        Dim NetPrice As Double = OrigPrice - DiscountValue + TaxValue
        Dim Result As String

        Result = "Original Price: " & vbTab & CStr(OrigPrice) & vbCrLf & _
                 "Discount Rate: " & vbTab & CStr(Discount) & "%" & vbCrLf & _
                 "Tax Amount: " & vbTab & CStr(Tax)
        MsgBox(Result)

        Return NetPrice
    End Function

    Public Function Main() As Integer
        Dim FinalPrice As Double

        FinalPrice = CalculateNetPrice()
        MsgBox("Final Price: " & CStr(FinalPrice))
        Return 0
    End Function

End Module

This would produce:

Optional Arguments

Optional Arguments

If a procedure takes more than one argument as above, remember that some arguments can be specified as optional. In this case, when calling the procedure, any argument that does not have a default value must be passed with a value. When creating a procedure that takes more than one argument, the argument(s) that has(have) default value(s) must be the last in the procedure. This means that:

  • If a procedure takes two arguments and one argument has a default value, this optional argument must be the second
  • If a procedure is taking three or more arguments and two or more arguments have default values, these optional arguments must by placed to the right of the non-optional argument(s).

Because of this, when calling any procedure in the Visual Basic language, you must know what, if any, argument is optional and which one is not.

If a procedure takes two arguments and one argument has a default value, when calling this procedure, you can pass only one value. In this case, the passed value would be applied on the first argument. If a procedure takes more than two arguments and two or more arguments have a default value, when calling this procedure, you can provide only the value(s) of the argument that is (are) not optional. If you want to provide the value of one of the arguments but that argument is not the first optional, you can leave empty the position(s) of the other argument(s) but remember to type a comma to indicate that the position is that of an argument that has a default value. Here is an example:

Public Module Exercise

    Function CalculateNetPrice(ByVal AcquiredPrice As Double, _
                               ByVal MarkedPrice As Double, _
                               Optional ByVal TaxRate As Double = 5.75, _
                               Optional ByVal DiscountRate As Double = 25) As Double
        Dim DiscountAmount As Double = MarkedPrice * DiscountRate / 100
        Dim TaxAmount As Double = MarkedPrice * TaxRate / 100
        Dim NetPrice As Double = MarkedPrice - DiscountAmount + TaxAmount
        Dim Result As String

        Result = "Price Acquired: " & vbTab & CStr(AcquiredPrice) & vbCrLf & _
                 "Marked Price: " & vbTab & CStr(MarkedPrice) & vbCrLf & _
                 "Discount Rate: " & vbTab & CStr(DiscountRate) & "%" & vbCrLf & _
                 "Discount Amt: " & vbTab & CStr(DiscountAmount) & vbCrLf & _
                 "Tax Rate: " & vbTab & CStr(TaxRate) & "%" & vbCrLf & _
                 "Tax Amount: " & vbTab & CStr(TaxAmount)
        MsgBox(Result)

        Return NetPrice
    End Function


    Public Function Main() As Integer
        Dim FinalPrice As Double

        FinalPrice = CalculateNetPrice(225.55, 150.55, , 40)
        MsgBox("Final Price: " & CStr(FinalPrice))
        Return 0
    End Function

End Module

This would produce:

Optional Arguments

Optional Arguments

 
 
   
  =================================================  
Home

Overloading a Procedure

 
 

Introduction

 

A program involves a great deal of names that represent variables and procedures of various kinds. The compiler does not allow two variables to have the same name in the same procedure (or in the same scope). Although two procedures should have unique names in the same program, you are allowed to use the same name for different procedures of the same program following certain rules.

 

Overloading a Procedure

The ability to have various procedures with the same name in the same program is referred to as overloading. The most important rule about procedure overloading is to make sure that each one of these procedures has a different number or different type(s) of arguments.

Practical LearningPractical Learning: Overloading a Procedure

The moment of inertia is the ability of a beam to resist bending. It is calculated with regard to the cross section of the beam. Because it depends on the type of section of the beam, its calculation also depends on the type of section of the beam. In this exercise, we will review different formulas used to calculate the moment of inertia. Since this exercise is for demonstration purposes, you do not need to be a Science Engineering major to understand it.

The Moment Of Inertia

  1. Start Microsoft Visual Basic and create a Console Application named MomentOfInertia1
  2. In the Solution Explorer, right-click Module1.vb and click Rename
  3. Type MomentOfInertia.vb and press Enter
  4. To calculate the moment of inertia of a rectangle, change the file as follows:
     
    Module MomentOfInertia
    
        ' Moment of Inertia
        ' Rectangle
        Private Function MomentOfInertia(ByVal b As Double, _
                                         ByVal h As Double) As Double
            Return b * h * h * h / 3
        End Function
    
        Public Sub Main()
            Dim Base As Double, Height As Double
    
            Base = InputBox("Enter the base of the Rectangle")
            Height = InputBox("Enter the height of the Rectangle")
    
            MsgBox("Moment of inertia with regard to the X axis" & vbCrLf & _
                   "I = " & CStr(MomentOfInertia(Base, Height)) & "mm")
        End Sub
    
    End Module
  5. Execute the application
  6. Enter the base as 3.25
     
    Overloading a Procedure
  7. Enter the height as 2.85
     
    Overloading a Procedure
     
    Overloading a Procedure
  8. Close the DOS window and return to your programming environment
  9. Here are the formulas to calculate the moment of inertia for a semi-circle:
     

    The Moment of Inertia for a Circle

    A circle, and thus a semi-circle, requires only a radius. Since the other version of the MomentOfInertia() function requires two arguments, we can overload it by providing only one argument, the radius.

    To calculate the moment of inertia of a rectangle, change the file as follows: 

    Module MomentOfInertia
    
        ' Moment of Inertia
        ' Rectangle
        Private Function MomentOfInertia(ByVal b As Double, _
                                         ByVal h As Double) As Double
            Return b * h * h * h / 3
        End Function
    
        ' Semi-Circle
        Function MomentOfInertia(ByVal R As Double) As Double
            Const PI As Double = 3.14159
    
            Return R * R * R * R * PI / 8
        End Function
    
        Public Sub Main()
            ' Dim Base As Double, Height As Double
            Dim Radius As Double
    
            ' Base = InputBox("Enter the base of the Rectangle:")
            ' Height = InputBox("Enter the height of the Rectangle")
            ' MsgBox("Moment of inertia with regard to the X axis" & vbCrLf & _
            '       "I = " & CStr(MomentOfInertia(Base, Height)) & "mm")
    
            Radius = InputBox("Enter the radius of the semi-circle:")
    
            MsgBox("Moment of inertia of a semi-circle with " & _
    	       "regard to the X axis:" & vbCrLf & _
                   "I = " & CStr(MomentOfInertia(Radius)) & "mm")
        End Sub
    
    End Module
  10. Execute the application
  11. Enter the radius as 6.35
     

     
  12. Close the DOS window and return to your programming environment
 
 
     
 

Home Copyright © 2008-2024, FunctionX Monday 14 February 2016