Description
📊 Free Workbooks: https://www.excelvbaisfun.com/links?utm_source=youtube&utm_medium=desc&utm_content=VP6KdZD-45s
🥷Join Excel Ninja Pro: https://www.excelvbaisfun.com/ninjapro🔥(2 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/exgrid-in-excel-free-crash-course/
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/