Add an amount to a cell using a function procedure called from a Sub procedure

[D_Licious]

Hi everyone,

I'm trying to add an amount to a cell using a function procedure called from a Sub procedure. I know you could do this with just a Sub directly, but I want to learn how to do it via calling a Function from a Sub.

So I have these 2 procedures (1 Sub & 1 Function):

Function Addtothatcell(cell)
Addtothatcell = cell + 1
End Function

Sub CallThatStuff()

Addtothatcell (e3)

End Sub


As you can see, I'm trying to use the Sub to "call" the Function. And what it ultimately needs to do is add 1 to whatever is in cell E3. When I run the "Sub CallThatStuff", it's not giving me an error, but it's also not adding the 1 to the cell. Does anyone know what is wrong?

thanks,

 

[GWteB]

A simple solution would be

Function Addtothatcell(cell)
    Addtothatcell = cell + 1
End Function

Sub CallThatStuff()
    [e3] = Addtothatcell([e3])
End Sub

but if you don't understand what's going on I would recommend to take a look over here:

Short Guide to Better VBA

Following are some guidelines to improve your VBA skills and macro writing. Writing macros in Excel uses Visual Basic for Applications (VBA) and so in a way you are programming. As with nearly all programming languages this means you have to use a logical approach and be accurate. VBA has a...

www.mrexcel.com

 

[D_Licious]

A simple solution would be

Function Addtothatcell(cell)
    Addtothatcell = cell + 1
End Function

Sub CallThatStuff()
    [e3] = Addtothatcell([e3])
End Sub

but if you don't understand what's going on I would recommend to take a look over here:

Short Guide to Better VBA

Following are some guidelines to improve your VBA skills and macro writing. Writing macros in Excel uses Visual Basic for Applications (VBA) and so in a way you are programming. As with nearly all programming languages this means you have to use a logical approach and be accurate. VBA has a...

www.mrexcel.com

 

[D_Licious]

That solved it. thank you. Yes I'll look at that link you provided to improve my knowledge.

 

[GWteB]

You are welcome. Good luck and happy coding