Thanks for your series, I've learned so many fundamental concepts that were glossed over in other youtube vba videos. Please keep making more advanced videos.
A tip for viewers. I do this: for procedures I never use parenthesis and helps me distinguish procedures from functions. There's a point where I have so many functions and subprocedures that use arguments, that if I use all with parentheses, I will just get confused. Another thing to tidy your code is to use functions for returning values and subs for actually executing something. Great vid as always my friend...
WiseOwlTutorials - u made excellent videos. Thank u very much for such great videos. Could u plz clarify how it works in memory if we use the same variable name in both the argument and parameter
Being unaware of the lessons in this video, my technique to distinguish btwn functions & subs is prefixes. I name all subs with “sub” prefix & all functions with “fct” prefix. Works great for me. I also use data type prefixes when naming variables & arrays: “str” for string; “lng” for long integer; “i” for integer; etc.
Thanks, Andy. I *never* would have figured this out on my own. Very good to know. Do you know if named assignment using := forces a ByVal or ByRef assignment?
Best best best of TH-cam VBA so far
Thanks for your series, I've learned so many fundamental concepts that were glossed over in other youtube vba videos. Please keep making more advanced videos.
A tip for viewers. I do this: for procedures I never use parenthesis and helps me distinguish procedures from functions. There's a point where I have so many functions and subprocedures that use arguments, that if I use all with parentheses, I will just get confused.
Another thing to tidy your code is to use functions for returning values and subs for actually executing something.
Great vid as always my friend...
WiseOwlTutorials - u made excellent videos. Thank u very much for such great videos. Could u plz clarify how it works in memory if we use the same variable name in both the argument and parameter
Being unaware of the lessons in this video, my technique to distinguish btwn functions & subs is prefixes. I name all subs with “sub” prefix & all functions with “fct” prefix. Works great for me. I also use data type prefixes when naming variables & arrays: “str” for string; “lng” for long integer; “i” for integer; etc.
Your training videos are awesome. Keep doing a great work!
Thanks for the clarification Andrew.
thank you
You're welcome!
Thanks, Andy. I *never* would have figured this out on my own. Very good to know.
Do you know if named assignment using := forces a ByVal or ByRef assignment?
Hi Jim, glad you found it useful! Using named parameters doesn't affect whether an argument is passed by ref or by val.
@@WiseOwlTutorials Thanks!
@@jimfitch No problem Jim!
Hi, Can you please Make Videos of Libreoffice _STAR BASIC macros -Videos Series
Thanks for the suggestion but I don't think that's something we'll be doing in the near future, sorry!
@@WiseOwlTutorials Because, There is No proper video series in Star Basic......
OMG , I'm sorry , I could not understand basic things due to language or some other reason that why we must use () instead of ".😑