Excel VBA Basics #11 Create your Own Custom Functions with or without Arguments

Please login in order to report media.

  • Uploaded 8 months ago in the category How to programming

    How to make a function using VBA.

    In this lesson, we make 2 functions from scratch, =Lastrow() and =LastrowC().

    Lastrow function, when typed into any cell, gives the row number of the bottom most cell in column one.

    LastrowC function allows the user to click on any cell for its argument and it will find the lastrow in whatever column the selection was in.

    **Limited Offer** Learn to Make Excel Do Your Work For You with The Ultimate Excel Programmer Course – Get the Full 9+ Hour Premium Course for 75% off using coupon code: https://www.udemy.com/ultimate-excel-programmer/?couponCode=2016YOUTUBE75 Click Now to Order and get Lifetime Access to Course, Workbooks, Updates and Support!
    ------------------------
    Create Your Own Barcode Lookup System Using Excel VBA.

    Learn to Make Your Own Barcode Labels the Easy way and have fun with Barcode Scanners to Automate your Workflow! In this project-driven Course, you’ll learn to Build your own Custom Inventory System with Step-By-Step video instructions.

    This goes in depth into some advanced Userform strategies that you can use for your other projects to come.

    A great weekend study! YouTube Subscibers only pay one forth! Get your 75% off Coupon here: https://www.udemy.com/barcodes-excelvba/?couponCode=2016YOUTUBE75
    ------------------------
    Too busy to Learn Piano? Use my Secrets and Play Your Favorite Songs Today! Did you know; You can learn 4 basic chords in about 5 minutes and instantly be able to play millions of songs.

    Seriously, check this course out.

    75% off for my YouTube Friends! Click here: https://www.udemy.com/play-piano-by-ear-today-supercourse/?couponCode=2016YOUTUBE75

    For Articles, Updates and to Contact me for Consulting or just to drop me a line, please visit http://www.ExcelVbaIsFun.com


    To download this FREE workbook(source code included): Click the link below.



    http://excelvbaisfun.com/mdocs-posts/excel-vba-basics-11-create-your-own-custom-functions-with-or-without-arguments/

    ------------------------
    Playlists:
    Excel Vba Basics http://www.youtube.com/watch?v=AIhKNNXzZLM&list=PLw8O1w0Hv2ztGjIkrW7suD6oNDaOk3vbR&index=1
    Tips N Tricks https://www.youtube.com/playlist?list=PLw8O1w0Hv2zsPU-k2vPZ_6brD5Gk1sVy_
    Userforms https://www.youtube.com/playlist?list=PLw8O1w0Hv2zvnLFyiMrihcaOqA0sT0X2U
    Sample Excel Programs https://www.youtube.com/playlist?list=PLw8O1w0Hv2zuP-BE7tV1UjWa0ZexZqY89
    Events Series https://www.youtube.com/playlist?list=PLw8O1w0Hv2zvf-YaBApsIHloI9G6Cq1Wh
    Activex Controls https://www.youtube.com/playlist?list=PLw8O1w0Hv2zupzNIWkZCOYYngTtMH5nSf
    ------------------------

    Grab an Excel Nerd T-Shirt or Hoodie:
    http://ExcelVbaIsFun.spreadshirt.com/

    ------------------------
    Interact and Follow me on:
    LinkedIn: http://www.linkedin.com/in/danielcstrong
    Facebook: https://www.facebook.com/Excelvbaisfun/
    Twitter: https://twitter.com/ExcelVbaIsFun
    Google Plus+: http://www.google.com/+ExcelVbaIsFun


    'Royalty Free Music by http://audiomicro.com/royalty-free-music'

  • excelvbabasics11createowncustomfunctionsarguments