About ExcelVbaIsFun

---

Learn how to write programs in Excel and use Visual Basic code to automate your experience. Using VBA, you can write custom reports that will clear out and re-write each time you run. You can do anything from hiding a worksheet to running advanced searches and custom functions - all with simple visual basic code! Join me as we learn the exciting and little known secrets of Excel - behind the scenes.

Excel Grid Control - Adding Multiple Columns, Using HITEM to Read/Write Any Column [Free Download]

In this video, we'll show you how to add as many columns as you want to an Excel Grid (ExGrid) control on a worksheet. We'll also dive into an important concept in using rows in ExGrid (called Items) - the HITEM. ExGrid automatically assigns a new unique identifier every time you create a new Item…

---

Grids in Excel Part 05 - Adding A New Item aka Row

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 …

---

Using Grids in Excel Part 04 - Making A Column & Assigning Column Caption [Free Download 2022]

In this free training episode, we learn how to create new columns in ExGrid as well as how to set up the caption. It's super easy. You can do it on a blank sheet or download our pretty Workbook below. 📁 Free Download: https://www.excelvbaisfun.com/sdm_downloads/grids-training-02-01-add-columns/ 📁 C…

---