Min(), Max() in VB

[Jack]

Apparently there is no Min or Max function in VB, a programmer needs to do the following

Min --> IFF(a<b,a,b) Max --> IFF(a>b,a,b)


Clearly I can build my own but I find it hard to believe a built in function doesn't exist.

[urysohn]

If you are using VBA (Visual Basic within Excel, for example) you can use many worksheet functions, including Min and Max. Just use:
answer = Application.Min(myRange)
If you are not using the Excel version, I don't have much of a reply. I would create a public function for Max and Min and either place them in a publically avaialable area or have them handy to copy/paste when needed.

[Ben Kenobi]

The IFF makes me think you're programming in Access, and I have more than once missed MIN() and MAX() there myself. For Urysohn's version to work in Access, you'd need to link in the Excel library, which is probably more painful than defining the functions yourself.

[Cho Da]

in Acess you need to use IIF not IFF.

[Ben Kenobi]

:oops:

[Thrashard]

How about domain Agg Functions?

DMAX and DMIN? They come in handy.....

[Jack]

I'm programming in VB not in Excel or Access. Yes, it's IIF I made a typo.

I'm not familiar w/ agg functions, can you point me in the right direction.

Thanks

[Huki]

Apparently there is no Min or Max function in VB, a programmer needs to do the following

Min --> IFF(a<b,a,b) Max --> IFF(a>b,a,b)


Clearly I can build my own but I find it hard to believe a built in function doesn't exist.
You don't need a Min or a Max function in VB. If you did, the folks at Microsoft would have built them in.

[Arlie_Proctor]

Huki:

Not quite. If min and max were truly needed, Microsoft would have offered a developers' toolkit (at additional cost) that included them :swear:

[Huki]

You're right, of course.