VBA - Is This Possible ?

[GeyikBaba]

Excel 2010:

I have not used VBA much in Excel, but a lot in Access.

Is it possible to write a function like:

Function AddTwoCells( lA as Long, lB as Long) as Long

AddTwoCells = lA + lB

End Function

Then call the function by entering =AddTWoCells(A2, B2) into cell C2, for example.

I have a complicated string concantenation to perform over a couple of hundred rows. The =IF() function would work, but would be way to cumbersome and hard to maintain.

Looking at my book and at the internet, all I find is code which is run by the 'Run' command.

The idea would be to paste the function/formula into the 200 cells, then special copy the resulting values manually into a different file.

When I try this, I just get the #NAME error in the cell - it's not seeing the function even though I've declared it as public.

Thanks
Mike Thomas

 

[nouseforaname1982]

What about defining C2 as "=A2 & B2"

so if A2 = "14" and B2 = "ABC" than C2 = "14ABC"

 

[GeyikBaba]

Thanks for your reply. I was just using the A2 & B2 as an example. As I mentioned in my email, the real function will be far more complex than that, that's why I want to define a function.

My problem is not the VBA code, it is getting the cell to be able to 'see' or access the function.

If I could get this simple function to worj, then I can get teh complex one to work.

Mike Thomas

 

[Ruddles]

You're on exactly the right lines. You pass the parameters to the function and the value of the function is returned to the cell.

Try it with your simple function first to satisfy yourself that it works, then write your more complex function. If you get stuck, come back here and there will be any number of people willing to help you.