Use Variable Names in Large Function (VBA)

[SidKol]

Dim Value1 As Double
Dim Value2 As Double
Dim Value3 As Double

'Example values
Value1 = 1
Value2 = 2
Value3 = 3


How can i get the Largest value using the names of the variables?

So something like:

= Application.Large((Value1, Value2, Value,3), 1)

 

[Fluff]

How about

MsgBox Application.Large(Array(Value1, Value2, Value3), 1)

 

[SidKol]

Awesome! Thanks a lot!

 

[Rick Rothstein]

Alternately, instead of individual variables that you have to bundle up into an Array function, you could use an actual array and pass that directly...

Sub Test()
  Dim Value(1 To 3) As Long
  Value(1) = 1
  Value(2) = 2
  Value(3) = 3
  MsgBox Application.Large(Value, 1)
End Sub