Channel: ExcelVbaIsFun

Category: Education

Tags: activex control in excel vbaexcelvbaisfunactivex control in vbactivex controls exceldan strongexgridexontrol

Description: In this video, we'll talk about adding a new Item or Row inside of our Excel grid (ExGrid) control. In our previous lesson, we learned how to add a Grid control on a worksheet and how to add a new column and put a custom Column caption. Now, we're going to get a bit more granular with our grid and add items, with is the basis for any table or grid. These are like rows in Excel. Later, we'll learn how items can be used as parent items for child items in a Treeview format that can be expanded/collapsed. 📁 Free Download: excelvbaisfun.com/sdm_downloads/grids-training-02-02-add-row-or-item 📁 Completed File: excelvbaisfun.com/sdm_downloads/grids-training-02-02-add-row-or-item-completed-file 📊 Get ExGrid: excelvbaisfun.com/GridHelp 00:00 Intro - Row vs Item 00:22 Adding New Sub/Macro 01:28 What's an HITEM? 01:45 Testing Code (Step Through in Break Mode) 02:01 Exploring new Item/Row 02:22 Get these FREE workbooks 02:30 More content from Dan Learn More: excelvbaisfun.com/GridHelp 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 #ExcelVbaIsFun #DanStrong #ExGrid 'Royalty Free Music by audiomicro.com/royalty-free-music'