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

Опубликовано: 24 Октябрь 2024
на канале: ExcelVbaIsFun

2,301

📊 Free Workbooks: https://www.excelvbaisfun.com/links?u...
🥷Join Excel Ninja Pro: https://www.excelvbaisfun.com/ninjapr... Months FREE On Annual Plan Auto Applied)
🥷Excel Ninjas FB Group: https://www.excelvbaisfun.com/xlninjas (Free downloads, Trainings, Live Q&A and more)

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: https://www.excelvbaisfun.com/sdm_dow...
📁 Completed File: https://www.excelvbaisfun.com/sdm_dow...
📊 Get ExGrid: https://www.excelvbaisfun.com/GridHelp

Fantastic Developer Tools:
🔒 Transform Any Excel File Into A Locked EXE: https://www.excelvbaisfun.com/secure-... (25% off with code ‘25OFF’)
🟡 Create Custom Installers: https://www.excelvbaisfun.com/custom-...
👋 Business Inquiries, Consulting, Comments, etc: https://www.excelvbaisfun.com/contact/

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