VBA - InputBox

[jazmincita]

Hi there,

I'm a beginner in VBA and I'm trying to write an algorithm that asks the user 5 values and then the system has to display the maximum value written by the user
I thought about doing an Input Box 5 times, with for... next but I'm stuck as I don't know how to display the maximum value.

I'm stuck.

Thanks for your help!

 

[Joe4]

Welcome to the Board!

You can enter the values into an array, and then take the max value of the array like this:

Sub MyMax()

    Dim arr(1 To 5) As Long
    Dim i As Long
    
'   Prompt the user 5 times for values
    For i = 1 To 5
        arr(i) = InputBox("Please enter in value number " & i)
    Next i
    
'   Return the maximum value
    MsgBox "The maximum value entered is " & WorksheetFunction.Max(arr)
    
End Sub

 

[jazmincita]

Thanks a lot!

 

[Joe4]

You are welcome.
Glad I was able to help!