Using vba functions in cell formula

Question

I need to round two values and sum them then. The problem is, I have Czech version of MS Excel, and rounding function is called "Zaokrouhlit"

enter image description here

So my formula looks like =ZAOKROUHLIT(A1, 2) + ZAOKROUHLIT(A2, 2)

Now I'm thinking, what if I send my file to someone that is using excel in different language version, will it work?

So I tried default function =ROUND(A1, 2) + ROUND(A2, 2)

enter image description here

But my version of excel doesn't know anything about such a function.

Fortunatelly, I can use this function inside VBA subroutines, so my question is:
How to use VBA function inside formula?

If you try changing your system locale does your computer recognize the English function names? Just a guess, might not work but worth a shot. — David Zemens
– David Zemens, Commented Apr 13, 2013 at 21:48
This is not a real solution. If I send the file to somebody I would have to expect (ask) them to have the "right" system locale set in their computer too. — Buksy
– Buksy, Commented Apr 13, 2013 at 21:51
in my opinion it will work for all formulas which you already have in your sheets. For those which you would like to apply (on other computer) from VBA use .Formula or .FormulaR1C1 and avoid using .FormulaLocal or .FormulaR1C1Local properties in your subroutines. — Kazimierz Jawor
– Kazimierz Jawor, Commented Apr 13, 2013 at 21:51
@Buksy I was not proposing a solution, I was simply trying to get to the root of the problem. There are likely ways around this just like there are ways around problems inherent to conflicting international date formats, etc. — David Zemens
– David Zemens, Commented Apr 13, 2013 at 23:34

Community · Accepted Answer · 2017-05-23 12:12:35Z

2

try these localization solutions:

there are several answers, and between them they should help you

CommunityBot

11 silver badge

answered Apr 13, 2013 at 21:52

6,00525 gold badges104 silver badges158 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

I have not had to deal with situations like this; the links are very helpful. I think they should help OP solve the problem.