I just had a peek at the first video in that guy's Excel VBA Tutorial sequence. It is very low-level and worse yet he shows examples using incorrect syntax (that happens to work, by luck, in the degenerate case presented).
However it probably won't damage you too much if you can grit your teeth and sit through a very low level intro, with an awareness that the guy isn't very expert and may do some really bone-headed things.
In his first Excel VBA video he uses:
Which is of course incorrect, and should be:
MsgBox ("Hello World!")
MsgBox "Hello World!"
Subroutine calls do not use parentheses around their list of arguments. What he did was tell the interpreter (actually the IDE's incremental p-code compiler) "evaluate this expression and pass its value."
This will fall apart as soon as he needs to supply some of the optional parameters:
Will fail due to incorect syntax. properly written it would be:
MsgBox ("Hello World!", vbOkOnly, "Title")
So the videos are guaranteed to be flawed, though probably useful as a view of use of the tools. Note that untold number of books have the same kinds of silly mistakes! Some of them get contrarian and recommend the obsolete QBasic-style syntax:
MsgBox "Hello World!", vbOkOnly, "Title"
Note that the IDE pulls out the space before the "(" even if you manually force one in.
Call MsgBox("Hello World!", vbOkOnly, "Title")
This works, but it's a crude hack, generally best avoided.