Excel VBA Introduction Part 18 - Creating Functions

By Andrew Gould

[janezklun]

After more than seven years, still great tutorial, thank you

[ghoomketu.forever]

These are probably the best tutorials I've seen on youtube. Kudos!!

[ashokkandukury]

nOW i AM ABLE TO DO SOME THING NEW IN EXCEL WITH VBA ; YOUR LECTURES INSPIRED ME TO DO THAT. YOU aNDREW.

[wayneedmondson]

Hi Andrew.. thanks for this great tutorial on creating and using custom functions in VBA. Here's a tip.. when using a custom function on the worksheet, you can use the keyboard shortcut CTRL+SHIFT+A after opening the function.. meaning you've typed in a cell: =CustomDate( .. and you will see the argument list for the function appear, as in: =CustomDate(DateToFormat, IncludeTime). This is the same behavior as for a built-in EXCEL function and it also works for custom functions. It is not quite as good as a true argument list like on an in-built function, but it can help if you forget your arguments or the order in which you specified them. Thought this tip might be useful to anyone who does not know about it. Thanks again for all of your great tutorials and Thumbs up!

[uditkapoor]

What a co-incidence. Watching this video on your brother's birthday. Happy birthday to him.
And a big thank you for all the videos. :D :D :D

[USSBARBEL]

I learned so much from this - Thank you for taking the time to put together and share! Deeply in your debt.

[pradeeprawatvlogs]

your videos are awesome I am interested in the training programme but I can't afford and on the top of it I cannot visit the London as again it is out of my pocket but your youtube videos and blogs on the website help me a lot thanks a lot sir I express heartfelt gratitude to you

[tiisetsomashele]

Brilliant! Thank you so much. I only started understanding function procedures after I had watched this video

[vivianlu]

This is a great course. I want to know how many people have watched all the videos?

[amandafernandesramospasson]

your tutorials are great! thanks. i've learnt a lot!

[heathergray]

For anyone who wants to feel like a real programmer, when he breaks out the existing code into generic functions, that's calling "refactoring". Now you can feel cool when you say "I'm refactoring my code!" :P

[yashrajkanaskar]

Awesome stuff there man ! You solved my error issue! Thanks

[edtardaguila]

the video and tutorial was superb, this is useful specially if you running your code several times with dynamic results
thank you for sharing this cheers!

[illabillatilla]

thank you sir for sharing valuable knowledge

[karlmin]

It's great for programmers, we can even make a game with excel VBA.

[ouzytheoriginal]

very good clarified some of questions in my mind thanks

[nuhzakir]

I like your videos.Thank you.These are very useful.

[blauertoons]

Thank you sooo much for creating this =))
I have learned an incredible amount from your vids

[rihannababez]

Thank you for sharing valuable information!
Was searching alot for a proper video which would solve my doubt..explained very well👌🏻🙌🏻

[maurocastagnera]

Dear Andrew, given that I think you're really a genius, I would like to ask you how you can remind yourself of all this about the VBA! I've only seen a dozen of your videos but I already can not remember everything! I believe your students are really lucky to have a good teacher like you! I hope one day to come to England and congratulate you personally. It would be an honor for me. Thank you very much.