Function Wrapper in VBA #1: Forward Price function

Veröffentlicht am: 02 August 2019
auf dem Kanal: The Office Ninja

442

*********************************
Get my VBA Troubleshooter course for only $10 http://goo.gl/S5GIBk
*********************************

Function Wrapper in VBA #1: Forward Price function

Video description
----------------------------
The goal of my Excel VBA tutorials are to take you from a beginner level to a confident Excel VBA developer and programmer as quickly as possible. The best way to do this is to help you UNDERSTAND Excel VBA code and how to build robust Excel spreadsheets.

When building functions in VBA you want to make sure then end user (often just using it from an Excel Spreadsheet) has the best user experience possible. On possible way to ensure this is to use a Function Wrapper. A Function Wrapper can check inputs to make sure they are valid, perform error handling in VBA and make sure any outputs or error messages sent to the user are sensible. A key goal is to avoid things like cryptic VBA code execution error messages!

In this free beginner level Excel tutorial we use Microsoft Excel 2016 and you will learn:
1. How to build a simple bare bones function in VBA to calculate the forward price of an asset (e.g. stock price);
2. How to use VBA to build a simple test harness subroutine - this checks the function is behaving like it should using a simple known example;
2. In addition to the VBA subroutine test harness we will build an Excel worksheet test harness;

The video uses Excel 2016 but the same steps are used for Excel 2010, Excel 2013 and equivalent versions of Microsoft Access.

If you enjoyed this short tutorial then please add a comment, start a discussion, "Like", "Favourite" or "Share" the tutorial and subscribe to my channel.

Channel Links and Playlists
----------------------------
   / @theofficeninja

Understanding VBA Code playlist:    • Understanding VBA Code: Uber Lock down of ...
Official Channel Series:    • Microsoft Access Database Parameter Querie...

Other Useful Links
----------------------------

A full list of my Udemy courses can be found on my Udemy profile page: https://www.udemy.com/user/paulmorris...

My Excel VBA Troubleshooter course is here: https://www.udemy.com/become-a-vba-tr...

WiseOwl provides a lot of very good VBA tutorials:    / @wiseowltutorials

Sali Kaceli provides a lot of Excel and VBA related tutorials also:    / skaceli
Chip Pearson has a lot of VBA content - if Chip says you should do something ... you probably should: http://www.cpearson.com/

Thanks for watching!

Paul.

Auf dieser Seite können Sie das Online-Video Function Wrapper in VBA #1: Forward Price function mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer The Office Ninja 02 August 2019 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 442 Mal angesehen und es wurde von 8 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!

9,532

225