Excel VBA: passing arguments

Question

I am working on some Excel functionality using VB - but I am getting stuck at some examples. Current version is Excel 2007, using a blank Workbook; I've added in a module and trying a function like the following:

Function Addtwo(a, b)
  Addtwo = a + b
End Function

However, I get the error #VALUE! in my cell, when doing Addtwo(5,5). When trying to do Addtwo(B2,B3), Excel tells me my formula is wrong.

Thanks,

Codo · Accepted Answer · 2011-05-13 13:36:39Z

5

The pasted code is okay and works in my Excel 2007.

The only possible problems I can think of:

You forgot to use the equal sign: Addtwo(5,5) instead of =Addtwo(5,5)
Your language settings require a semicolon instead of a comma in the formula, i.e. =Addtwo(5;5) (in the worksheet formula only, not in the VBA code)

answered May 13, 2011 at 13:36

Codo

79.7k18 gold badges176 silver badges218 bronze badges

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

1 Comment

Shyam Over a year ago

Indeed, it is the language setting! Is the semi-colon friendly though to use in other Excel languages?

Collectives™ on Stack Overflow

Excel VBA: passing arguments

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related