explain how to use the window immediate in the VBA

Hello Guys!
I really want to learn VBA, But I don't know how to fix mistake when I wrote the code in VBA.
Example I have a file below.
I try to correct my mistake in the file when I use the Immediate (Ctrl+G) and enter it. so that result is name in this file.
But I can not fix mistake the code when I saw that.
Please tell me how to use and how to fix again my mistake.

Originally Posted by Kaper

As the filename is ...xlsx I assume there is no code ... so nothing to explain with your file.

Generally, with Immediate Window, you can for instance call some procedures, or chceck specific values during code execution. Probably while code is paused because of breakpoint or msgbox popped out, etc.

You can also assign some values to variables. But it is not the place to fix mistake in the the code. To manipulate code use simply Code window ( key <F7> ).

OH, I forgot save as xlsm, maybe I attached my file again.
Does not that window immediate fix break code.
If I write wrong a line code, How can I do with that code. If I can not remember how to write.
example with my file below

Originally Posted by Norie

What exactly are you trying to fix?

Is it the function TimTen?

yes exactly, I want to correct funtion Timten.
A4=TimTen(B2, B1:B29)
but in the sheet 1 Timten=value? so I want to fix my code.
When I try with this code
?TimTen(Range("E1").Value, Columns("B:B"))
in the window immediate I saw result: Lư Th? H?o.
So I dont know how to fix my code below monitor VBA.

Originally Posted by Kaper

Try such modification:

Please Login or Register  to view this content.

to avoid testing when sRng Is already Nothing the condition on sRng.Address (which is invalid if sRng is Nothing).

well done. thank you very much.
Exactly I am finding the result.
But sometime I have many problem with my code, but I can not find the way to fix it.
Please tell me how to write and fix break code?

Originally Posted by Kaper

Here I set the breakpoint at first instruction, edited a cell with functin call and once code execution stopped I went instruction-by-instruction using <F8> key.

I know, Thank you very much
breakpoint by F8