"Math." calls???

User avatar
ErikJan
BronzeLounger
Posts: 1253
Joined: 03 Feb 2010, 19:59
Location: Terneuzen, the Netherlands

"Math." calls???

Post by ErikJan »

I noticed this in some code: Math.Round(number)

I wasn't aware of that function in VBA, tried to look for references (e.g. what else can I place behind the dot... Math.Average doesn't work) but couldn't yet find them... Someone you can point me to more info here?

User avatar
HansV
Administrator
Posts: 78524
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: "Math." calls???

Post by HansV »

Press F2 in the visual basic editor to start the Object Browser.
Type math in the search box and press Enter.
S166.png
You don't have to use Math.
Just Round (etc.) will work.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans