Predict The Output

[Oorang]

Try to guess the final values of i, j, & k before you run the code.

Option Explicit
Sub PredictTheOutput()
    Dim i&, j&, k&
    i = 10: j = i: k = i
    MySub (i)
    MySub j
    MySub k + 20
    MsgBox Join(Array(i, j, k), vbNewLine), vbQuestion, "Did You Get It Right?"
End Sub
Public Sub MySub(ByRef foo As Long)
    foo = 5
End Sub

I got "i" wrong.

 

[Patience]

I didn't quite understand the question at first - but when I thought it through (several times) I realised what I was doing was right. Just that the answers I was getting were wrong. I only got i right.

 

[TinaP]

d'oh!

 

[Stormseed]

Oorang,

Could not you think of something else, some fun like your other thread which was Question & Answer type ? It was good fun.

This one is again the same thing that we all do on Excel Questions board room.

 

[MorganO]

Very interesting bit of code!

I've learned a few things I didn't know about how VB works, but still do not understand one piece. I won't ask directly about it just yet to give others an opportunity to look and guess, but am wondering if you are going to provide a step by step look at how the 'MySub' routine is working on the passed values.

Thanks for the challenge!

Owen

 

[Oorang]

Will do, let's give it a litte more time though

 

[Norie]

Owen

Why not set up some watchs on variables, sprinkle the code with a few breakpoints and stir with F8?

That should give you some insight on how the code is working.

PS I cheated and ran the code before guessing but I've not voted because I don't understand the poll.

Oorang

Do you work for some government organisation that creates polls just to confuse people?

 

[ZVI]

I’ve been cautious as well as … wrong at the assumption of 'i' estimation.

Amazed has thought about the difference on syntax and at last has understood that received result of code was absolutely correct from the point of VBA-parsing rules view

Nice brick of VBA wall, thank you!

 

[Richard Schollar]

I technically only got 1 right (j=5) but my defence is that I wasn't wearing my glasses and thought the assignment lines were:

i=1;j=1;k=1

 

[Domski]

Not 42 then?