Channel: ExcelVbaIsFun

Category: Education

Tags: excel vba full courseexcelvbaisfundan strongexgridexontrolgrid in excel

Description: In this series, we'll learn the basics of using a Grid control in Excel that gives you absolute control over your data! What is a grid? A grid is a special control that helps you edit and control your data in the safest, quickest and frankly sexiest way possible. It makes it easy to sort, filter, use scrollbars, use icons, date pickers, color pickers, special editing capabilities, super speed, grouping, aggregate functions, skinning. It goes way way beyond using a ListBox, Listview, or MSFlexgrid control. In this series, I'm going to show you how to use the grid, so if you want to follow along, pause the video really quick and grab the installer below! 👉 excelvbaisfun.com/GridHelp This free video series will be part of my 8+ hour course on the topic of the grid control (not excerpts from the course). These are full video from the course so you can get started with the ExGrid easily. The problem with using ListBoxes to protect your data is that you’re very limited in the way that you present them and you can’t edit them directly. You can use them to select another entry and edit the underlying data using form fields that populate based on your selection, but it’s mostly just for selecting an item. With a grid, you can edit a field directly on the grid while the underlying data is protected. Maybe it’s in a database or a hidden sheet and you use a UserForm or home sheet to access the data using your grid. 00:00 Intro - What is a Grid? 01:10 ListBox vs Grid 03:48 Expandable Columns can Sort and Edit multiple cell types 04:06 Editable cell types: Numeric, String, Date, Spin, Calculator 04:44 Aggregate functions (SUM, COUNT, AVERAGE, MIN, MAX) in Grids 05:13 HTML formatting inside Grid cells, columns etc 05:56 Masking patterns (in-cell validation) 06:18 Connecting to databases example 06:47 HD Images on Userforms and sheets, color-pickers 07:13 Use checkboxes and child-items; partial checkbox demo 07:38 Advanced Grouping methods and events 08:02 Apply custom Filters for any column 08:30 Enable/disable Group or filter on any columns 08:41 Multi-column grouping 09:07 Custom skinning types 09:41 Grid Style Editor 09:57 Live filter prompt feature 10:49 More info, Get Demo Get My Other 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 #ExcelVbaIsFun #DanStrong #ExGrid 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'