How can we find the maximum and minimum values in VBA?

In VB, you can use the Max and Min methods of the Math class to calculate the maximum and minimum values.

For example, the following code demonstrates how to find the maximum and minimum values of an integer array:

Dim numbers() As Integer = {10, 5, 20, 15, 8}
Dim maxValue As Integer = Math.Max(numbers)
Dim minValue As Integer = Math.Min(numbers)

Console.WriteLine("最大值: " & maxValue)
Console.WriteLine("最小值: " & minValue)

The output will be:

最大值: 20
最小值: 5

Additionally, if you need to find the maximum and minimum values of two numbers, you can simply use the Max and Min methods of the Math class.

Dim a As Integer = 10
Dim b As Integer = 5

Dim maxValue As Integer = Math.Max(a, b)
Dim minValue As Integer = Math.Min(a, b)

Console.WriteLine("最大值: " & maxValue)
Console.WriteLine("最小值: " & minValue)

The output results are:

最大值: 10
最小值: 5