Visual Basic for Applications/Expressions

From Wikiversity
Jump to navigation Jump to search

This lesson introduces expressions.

Objectives and Skills[edit | edit source]

Objectives and skills for using expressions include:

  • Customizing a message box to solicit input from the user
  • Using the InputBox function

Readings[edit | edit source]

  1. Wikipedia: Expression (computer science)
  2. Wikipedia: Statement (computer science)
  3. Wikipedia: Order of operations
  4. Microsoft: Arithmetic Operators
  5. Microsoft: Operator Precedence

Multimedia[edit | edit source]

Examples[edit | edit source]

'This macro accepts user input and then displays double the value entered.

Option Explicit

Sub DoubleValue()
    Const Title = "Double Value"
    Dim Value As Single
    Dim Result As Single
    
    Value = InputBox("Enter a value:", Title)
    Result = Value * 2
    MsgBox Value & " * 2 = " & Result, vbOKOnly + vbInformation, Title
End Sub

Activities[edit | edit source]

  1. Arithmetic / Mathematical Operators
    1. Review ExcelFunctions.net: VBA Operators and Built-In Functions.
    2. Experiment with different arithmetic / mathematical operators to ensure you understand how they work.
  2. Order of Operations
    1. Review MathsIsFun: Order of Operations.
    2. Create a macro that demonstrates the order of operations for VBA operators.
  3. Age Calculations
    1. Create a macro that asks the user how old they are in years, and then calculate and display their approximate age in months, days, hours, and seconds.
  4. Temperature Conversion
    1. Review MathsIsFun: Conversion of Temperature.
    2. Create a macro that asks the user for a Fahrenheit temperature and then calculate and display the corresponding Celsius temperature or ask the user for a Celsius temperature and then calculate and display the corresponding Fahrenheit temperature. Include the input temperature in the output display. For example: 98.6 degrees Fahrenheit is 37 degrees Celsius
  5. Area Calculations
    1. Review MathsIsFun: Area of Plane Shapes.
    2. Create a macro that asks the user for the dimensions of different shapes and then calculate and display the area of the shapes.

See Also[edit | edit source]

References[edit | edit source]

Nuvola apps edu miscellaneous.svg Type classification: this is a lesson resource.