How to Return from a Function in 2 Minutes

[@grzegorz2852]

Paul, another great video. SUper helpful. When my professor asked me to write an essay about 'who do you want to be in the future?'. I wrote about u.

[@Excelmacromastery]

I've gone for a slightly different style in this video. Let me know if you think I should do more like this. Make sure to download the source code from the description below 👇

[@GkhnA]

Hey Paul, I don't mind the shorter videos, but (assuming there will be more of them) the previous, important ones will be lost among them. Maybe another channel for these and then one video here that will consolidate some short ones?

[@Excelmacromastery]

@@GkhnA Thanks for the feedback😀

[@Rasenmaehermann89]

As a VBA beginner, I found it stressful to catch all the info at the first time watching.(listening to you and thinking through the code presented) it's not an instagram story - it's supposed to be an educational video. 😅 Though, I liked your other video "How to get the Last Row in VBA". Thank you!

[@NAEEM_MALIK]

I was searching about that, this is amazing 😂

[@jaimesastre6393]

Very interesting the set and get différence with number or address.

[@darray7472]

Paul, love your channel! Thank you for all you do. This video was short, but packed full of useful information about functions, collections, and arrays. The style was good, but maybe make it a little longer and show your PrintCollection(coll) and PrintArray(arr) subs?

[@Excelmacromastery]

Thanks for the feedback.

[@Luth1us]

I would suggest you an approach considering those "best practices " Dos and Don'ts. In a practical way Declare or Not declare will not make a big difference regarding performance sake. Its more related to keep organised the code. The VBE was developed considering the absence of declaration. Would be great if you explore situations where the declarations really matter. Thank you for your videos.

[@Excelmacromastery]

Thanks for your suggestion Juliano. I have an article here on the Dim statement(excelmacromastery.com/vba-dim/). I might do a video on this in the future.

[@iamjojo999]

Although clip is short,I see a lot of useful concept. Thanks Paul. One little suggestion, it would be better if you can show how much speed difference between two syntax

[@Pedritox0953]

Very interesting when you have a bulk of variables and want to alter them with external procedures

[@mrsachu88]

Hi. I want to learn VBA. Nice playlists. But when I see the videos I am confused where to start from,likewise which playlist I should do first. Your guidance will be appreciated

[@homejonny9326]

Start by knowing a lot of Excel, without VBA. Cell adress, named ranges, relative and absolute reference, formulas, funcions, charts, graphiscs, excel tables, pivot tables.... Then, go to VBA. I recomment Excel Bible 2019 book.

[@vbaclasses3553]

@@homejonny9326 solid suggestion.

[@NaranRet]

Hi Paul, Amazing videos, super clear and to the point. However I have to admit that I miss a little more explanation in last case (collections) for example, what is the point in pasing a collection than later is already wiped out (Function GetCollection (coll as collection) : set coll as new collection ...) and then use it in a parameterless call ... ( set coll = GetCollection [ ?] ) . I am little confused... moreover, isn't this also a VBE Syntax error because parameter is not set as optional?) Thanks in advance Paul!

[@Excelmacromastery]

They are not matching examples. The first shows passing an empty collection and returning a new one by using the parameter. The second(the call to GetCollection) shows the recommended way by returning the collection.

[@logic3686]

I often times use subs instead of functions. Passing the array to the called sub program, having the subprogram update the array, and then when the sub exits the array is updated. Is this a bad practice and why?

[@Excelmacromastery]

As I show in the video it is better to use arrays this way as otherwise vba creates a copy which is not efficient.

[@logic3686]

@@Excelmacromastery Thanks, I review this. You are a Wiz!

[@pbs36]

I would just add that we can return values from a sub via ByRef parameters, which should be clearly named to show they're output parameters.

[@Excelmacromastery]

I covered that towards the end😀

[@hariadi9994]

you are really master of vba,,, but sadly you speak too fast,,,,,

[@thomasfergusen5144]

Hello, i have a question: "thisworkbook.save" code takes alot of time (even i did "Application.CalculateBeforeSave = False" and "Application.Calculation = xlCalculationManual") so i decided to use that code only in "Private Sub Workbook_BeforeClose(Cancel As Boolean)" subroutine. But the problem is when electric is off or somehow programme get a runtime error vba does not read the code. ( i dont want to get recovery offering because of users not familiar that) so what to do? Thanks!