Java'ish Return?

And now this is my 3rd post in this forums since I registered a few hours ago.

HOW IS VB / EXCEL SO HARD! *cry*

Pseudoishcode

Sub My_Sub()
     Call Return_Percent(5, 10)
     RETURN IS PASTED INTO CELL A1 ON SHEET 1
End Sub

Sub Return_Percent(X, Y)
     X*Y=Z
     Return Z
Sub End

Second Sub has been asked in another thread so that's not so important

What I am after is a generic method/sub that can take a a few simple variable's and return something that can be pasted into a cell.

What I am trying to do is build my own API that can be used by idiots, (EG Managers)

Hi Maull

If you only joined the Forum a few hours ago, you're off to a bad start.

Some of us "Idiots" actually belong to and participate in this Forum.

John

Hello Jaslake,

I am very sorry if I offended you, that was positively not my intent.

I simply said the thing about my manager because when I emailed him a Zip folder he tried to open it in Notepad.

Nuff said?

My boss is a not very tec savy, hence the need for me to build him a simple API that he can customise (I am moving onto another contract soon)

If my 1st post indicated that the ppl reading this were idiots I wouldn't have posted here, I'm after the experts! (Thoe I don't think it did offend anyone (I am hoping that you simply didn't read my post correctly) Do NOT want to make a bad impression in my 1st day!)

I would ask, out of of a debilitating need to be liked that someone post that Im not an ***?

Hi Maull

I don't prejudge. Don't know your Boss, don't know you. I've 69 years of "life experience". That experience has taught me to keep my disparaging thoughts in my head. I seldom express them and if I ever do, I'd NEVER put them in writing. Look at WikiLeaks for a perfect example of the issues that WILL crop up.

Your post didn't offend me as I've got pretty thick skin. However, I don't think I

simply didn't read my post correctly

Your post is what it is. Were I you, I'd amend the post and eliminate the disparaging comments. Your Boss may well see them which could well not be good for your career.

I have no clue how others on the Forum will react; my reaction is that I'll probably pass.

John

In Excel VBA, a user-defined function (UDF) generally returns a single value to the cell in which the formula that invokes it appears.

Function MySimpleSum(dAddend1 As Double, dAddend2 As Double) As Double
    MySimpleSum = dAddend1 + dAddend2
End Function

E.g., =MySum(A1, B1)

Subs that modify cells in other ways need to be invoked from a button, or an event, or other code.

I don't disagree with any of John's comments.

Hi Marcol

I guess because it's one of life's learning experiences "Too Old Soon, Too Late Smart". We all go through it...some embrace it...some don't. shg obviously has. I admire his work and his thoughtful responses.

As for us " geriatric idiots", as long as we're contributing, allow us to do so. When we're not, tell us.

I'll have a beer with you tonight.

John