Excel 365 Visual Basic Part 41– Custom Programming Techniques
The purpose of this chapter is to display common code that might give you interesting ideas. The code in this chapter can be used and adjusted to fit your own environment. Also, there is a way to create a library of code that you can commonly use. You would place all your code in a single Excel file and use it as an add-in program. The code will then be made available to you as you open Excel.
Video Series Part 41- This is a comprehensive guide to learning Excel from the basics to advanced programming techniques. These videos are labeled in order beginning with Part 1, 2, 3, 4, etc. Each video can be downloaded and freely distributed to anyone desiring to learn Excel in great depth.
Higher Quality Video: www.elearnlogic.com/media/excel365-5-ch11.mp4
- Click + Rumble if the video was helpful.
- Click Subscribe so you won’t miss out on any new videos.
- Click the Share button so you can help others expand their skills.
Each video provides a great overview of the concepts, but the courseware provides additional details for a better understanding. You will be able to follow along with the courseware while watching this video.
Courseware: Excel 365 – Visual Basic For Excel
The courseware is available on Amazon at: https://www.amazon.com/dp/1979929076
Chapter 11 - Custom Programming Techniques
The purpose of this chapter is to display common code that might give you interesting ideas. The code in this chapter can be used and adjusted to fit your own environment. Also, there is a way to create a library of code that you can commonly use. You would place all your code in a single Excel file and use it as an add-in program. The code will then be made available to you as you open Excel.
Section 1 - Custom Function Library
This is an easier way to make custom functions available at all times by storing them in a separate Workbook. The Workbook can then be saved as an Add-In (an XLA file) in your XLStart folder.
Section 2 - Custom Functions
One value of a workbook is to be able to understand the code. If you have already studied this workbook up to this particular chapter, you will notice many commands you have previously used. The following are a few functions that are available to review and use: User Defined Function, Select Row Range Example, Select Col Range Example, Outlook Email Example, Copy, Display Error Message, OnError3(), Clear a Column, Truncate Zipcode, and ZIPShorter().
This Courseware/Video is based on Excel 365 and documents command differences between Excel 2010, Excel 2013, Excel 2016, and Excel 2019.
If you have any questions, please contact: Jeff Hutchinson, Website: http://www.elearnlogic.com, Email: jeffhutch@elearnlogic.com
-
11:55
Microsoft Excel Full Course
3 years agoExcel 365 Visual Basic Part 40–Functions
183 -
32:47
Microsoft Excel Full Course
3 years agoExcel 365 Visual Basic Part 32 – Cell Manipulation
57 -
52:03
Excel For Freelancers
2 months agoHow To Master Shapes With Excel VBA - For Beginners
86 -
1:52:15
Excel For Freelancers
3 years agoLearn How To Create Excel Forms And Map Them To Tables From Scratch [GREAT FOR VBA BEGINNERS]
73 -
31:41
Excel For Freelancers
2 months agoVBA Beginners: Turbocharge Your Excel Development By Mastering Objects
48 -
10:04
The Excel Zone
1 year agoExcel Tips, Tricks and Shortcuts Part 2: Efficient Data Management
30 -
19:33
Excel For Freelancers
1 month agoThe Ultimate Error Handling Tutorial For Excel VBA Beginners + CHEAT SHEET DOWNLOAD
68 -
29:08
Excel For Freelancers
2 months agoHow To Master Arrays In Excel VBA + FREE MACROS & CHEAT SHEET
48 -
53:16
Excel For Freelancers
3 years ago $0.01 earnedThe Ultimate Excel Advanced Filters In VBA [Full Training Course]
32 -
33:55
Excel For Freelancers
3 years agoLearn How To Use These 7 Tricks To Speed Up Your Slow VBA Code In Excel
23