Get the highest value form 5 textboxes

[rwahdan1978]

Hi



I have 5 text boxes were the user will enter numbers and I have a button. When clicking the button I want to check which is the highest value and from which textbox, how to do that?

text1 = 5
text2 = 0
text3 = 2
text4 = 10
text5 = 7

so I will get text4 and value is 10

[Welshgasman]

Cycle through the textboxes within a loop.?

[CJ_London]

Something like

 

 Dim I as integer
dim ctl as control

set cal=text0
for I=1 to 4
    If me(“text” & I)>ctl  then set ctl=me(“text” & I)
next i 
debug.print ctl.name; ctl.value

in my phone so beware smart quotes

edit - modified code

[June7]

Should that be:

Set ctl = Me.text1

For I = 2 To 5

[CJ_London]

Yes, my mistake - I always try to work from base 0.

[Welshgasman]

TBF CJ did say 'something like' just to indicate the method, expanding on what I offered.
If the O/P cannot work from that, then we have a problem.

[señor_sriracha]

If you don't mind instantiating an Excel object, you could use its Application.Max() method.

Or you could roll your own method that accepts a parameter array, loop through them, and return the largest value.