You need to be logged in to view this content. Please login or become a member.

<<  Prev   |   Index   |   Next  >>

Description

VBA comes with many built-in functions for receiving user input, handling mathematical calculations, string manipulation, dates and time, and more. Learn about them here.

Notes

More VBA functions can be found here.

To test against tolerance values, it is common to use the Abs() function on the remainder of two Double values, and then compare that result to the tolerance. For example:


Dim dblVal1 as Double
Dim dblVal2 as Double
Dim dblTolerance as double
    
Sub main()
    dblVal1 = 48.39
    dblVal2 = 48.41
    dblTolerance = 0.01
    
    If Abs(dblVal1 - dblVal2) > dblTolerance Then MsgBox "Tolerance exceeded"
End Sub

Lesson Files

Lesson 1.6 – data conversion functions
Lesson 1.6 – date and time functions
Lesson 1.6 – InputBox function
Lesson 1.6 – MsgBox function
Lesson 1.6 – replace function
Lesson 1.6 – split function
Lesson 1.6 – string functions

Homework

Lesson 1.6 homework part A solution
Lesson 1.6 homework part B solution
Lesson 1.6 homework part C solution