Hello,

Are there equivalent functions for RoundUp RoundDown in VBA ?
On the cell if I put RoundDown(1234, -1) it gives me 1230
but I could not find a function to achieve this while writing this in a macro.
Do I need to do any inclusion ?
It gives "Sub or Function not defined" error for RoundDown on compilation.

For the time being, I wrote a dummy function to do the RoundDown as it was very urgent.

Also the Round function behaves diffently in VBA. It does not accept a negative num_digits parameter. i.e. Round(1234, -1) fails in VBA but works as "RoundDown" in the xls.

Is there no way to achieve RoundDown in VBA ??

Regards,

Parag

Application.WorksheetFunction.RoundDown(1234, -1)

What actuary is trying to say is that you can use excel functions in vba by using the WorksheetFunction property of the Application object.

In vba explorer, goto the the Object Browser (menu View - Object Browser (or F2)). Go through the classes until you find WorksheetFunction, then you will see all the members of it in the right hand pane. see attachment.

HTH.

Thank you for the detailed reply.
It is very interesting, I had never used WorksheetFunction in VBA.
That's great.
Thanks again.

How do I use Roundup function in VBA for Access 2007