MROUND Function Not Available in VBA

Hello,

I cannot get the MROUND(#,#) function to work in VBA. I'm working on a simple userform, and I need the scroll bar value to display in .25 increments. I have enabled the atpvbaen.xls add in for VBA, and the tool pack add in is also enabled in excel. I'm just not sure why the function is not available. When I try to call it with [atpvbaen.xls].MRound(#,#), I still get an error.

Please let me know if you have any suggestions.

Thank you.

Thanks for the quick response, I just tried that. I'm getting a run-time error '424': object required. Here is a sample of the equation that I used in the change event sub for the scroll bar I'm trying to use.

Label1.Caption = Appication.WorksheetFunction.MRound(ScrollBar.Value, 0.25)

Thanks for your help.

Please Login or Register  to view this content.

You've got a typo - "Application", not "Appication".

Thanks Andrew-R for the response, I fixed the typo, but I still get the same error. Application.WorksheetFunction.MRound(ScrollBar.Value, 0.25)

Yes, I do. Thanks for the reply.

Perhaps we could take the MROUND out of the equation, then:

Please Login or Register  to view this content.

Does that resolve the error?

Yes, that works thank you! I'm still curious as to why the Mround function doesn't work, but that can wait for another day

This seems to work

temp = Excel.WorksheetFunction.MRound(12.345, 0.25)