Channel: ExcelVbaIsFun

Category: Education

Tags: add multiple textboxesadd textboxesexcelvbaisfunvisual basic for applicationsexcel vba tutorial for beginnersdanstronguserformsdan strongexcel vbaexcel vba tutorial

Description: In this video, we learn how to dynamically combine the values of many textboxes on a Userform to do aggregate functions, such as the SUM or AVERAGE of these values. In the video, we'll learn expert tips to working with multiple textboxes and formatting strings as numbers so they work well for the task. We'll also learn how to use a loop to process many controls at once via the control's name. This works best when the controls have a sequential naming convention as you'll see in the video. 📁 Download Files: 🟡 Clean version: excelvbaisfun.com/sdm_downloads/how-to-add-multiple-textboxes-together-on-a-userform-sum-average-etc-clean 🟡 Completed version: excelvbaisfun.com/sdm_downloads/how-to-add-multiple-textboxes-together-on-a-userform-sum-average-etc-done 00:00 Intro 00:50 Tour of demo file 01:03 Download free demo files 01:50 Loop through controls 02:45 Get value from textbox by dynamic name 05:10 Step through code to test 06:34 Add the total field 07:20 Get the Average instead of Sum 08:42 Add Counter to the loop 10:10 Step through code to test 11:21 Run While Typing, Remove Button 14:05 Other Videos - Become an Excel Ninja Get My Bestselling Excel VBA Courses: Excel VBA Essentials Course: bit.ly/UltExcelVBA Control Websites With Excel VBA: bit.ly/VbaWebAutomation Speed Up Code With VBA Arrays: bit.ly/VbaArrays Create Your Own Functions/Addins: bit.ly/CustomUDFsAddins Fill PDFs/Forms with Excel VBA: bit.ly/VbaPDFsMastery Excel VBA Barcode Lookup System & Inventory Projects: bit.ly/VbaBarcodesProjects Instantly Secure Excel Files; Transform Into EXE Programs!: bit.ly/Excel2EXE Automate Outlook with Excel VBA: bit.ly/ExcelVBAOutlook Professional Animations In Excel by Kishon: click.linksynergy.com/deeplink?id=BYzUIhHF1Ys&mid=39197&murl=https%3A%2F%2Fwww.udemy.com%2Fmicrosoft-excel-animation-for-great-user-experience%2F Fantastic Developer Tools: Lock Any Workbook Into An EXE (Software only, see course above): excelvbaisfun.com/get-xlspadlock Create Custom Installers: excelvbaisfun.com/get-pb Free Ebook: excelvbaisfun.com/FreeEbook Dan Strong's Articles: excelvbaisfun.com/blog Free Excel Workbooks: excelvbaisfun.com/free-workbooks Business Inquiries, Consulting, Comments, etc: excelvbaisfun.com/contact ExcelVbaIsFun YouTube Playlists: Excel Vba Basics: bit.ly/ExcelVbaBasicsPlaylist Tips N Tricks: bit.ly/VbaTipsNTricksPlaylist Userforms: bit.ly/ExcelVbaUserformsPlaylist Events Series: bit.ly/VbaEventsPlaylist Activex Controls: bit.ly/VbaActiveXPlaylist Sample Excel Programs: bit.ly/SampleExcelPrograms Where else you can find me: LinkedIn: linkedin.com/in/danielcstrong Facebook: facebook.com/Excelvbaisfun Twitter: twitter.com/ExcelVbaIsFun Google Plus+: google.com/+ExcelVbaIsFun T-Shirts/Merch: ExcelVbaIsFun.spreadshirt.com 'Royalty Free Music by audiomicro.com/royalty-free-music'