Channel: ExcelVbaIsFun

Category: Education

Tags: excelvbaisfundan strongexcel vbagrid in excelexcel vba for beginners

Description: In today's video, we're going to do another free lesson from our Advanced Grid Course with Excel VBA where we're talking about the ExGrid control - specifically how it functions on a worksheet versus how it works and functions on a Userform. The primary focus of this lecture is how to put a grid on a worksheet versus putting them on a user form and a few subtleties between the two. There are not a lot of differences between the two but it's just helpful to plan. You may prefer using a grid on a worksheet that has a background image and maybe cells or you may want a pop-up Userform with your grid on it that can easily be closed and kind of swept under the rug if you will or moved away at will. Learn More: excelvbaisfun.com/gridhelp/?utm_source=youtube&utm_medium=desc&utm_campaign=Advanced+Grids+in+Excel+Part+3+-+Grids+On+Worksheets+vs+On+A+Userform 00:00 Intro 01:12 Putting ExGrid on a Worksheet 02:23 Putting ExGrid on a Userform 02:33 Make a Userform 03:23 Main Differences 04:22 Technical Demo - Template Designer 06:25 FYI About an Old Error (shouldn't be an issue any more) 07:28 Outro 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'