Excel Grid Control #11 - Detect Changed Items and Their Values

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

856

📊 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 episode, we're making grid items editable using incredible Calendar/ Date Picker controls as well as a Calculator field (which is really cool). We also review how to make text fields editable on the ExGrid control.

Get demo file and follow along 👉https://www.excelvbaisfun.com/gridhelp
Free ExGrid Course! 👉https://www.excelvbaisfun.com/courses...
00:00 Introduction
00:30 How to get the full course
00:47 Let's Dive In
01:53 Setting up Grid change event
03:57 Testing the event by triggering it
05:34 Grabbing value from other columns of triggered row/item
07:32 Quiz: How would you get Excel Row number for grid item that was changed?

👋 Business Inquiries, Consulting, Comments, etc: https://www.excelvbaisfun.com/contact/