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

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.

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?

[mohammadafsari]

Hi Thank you , question i have pms file i want to know is there any way to excel calculate by own and find 3rd date between start and finish date with formula and gives best match date between 2 start and finish date, it's example that can expand for 1000 tasks
Imagine i have 3 tasks with 5 days duration start is 1/1/22 and finish is 1/12/22 so first task start 1 day and 3rd task start 1/7/22 now I want excel calculate and find best date between in 2 tasks that must be 1/4/22
Now is there anyway excel calculate and find this date, this is can use for 1000 tasks more or less that I need to find it
tnx if you help me 🌹🌹🌹🌹
Thank you 🌹🌹

[boodahbellie]

Where did you get your date picker? I am using Office 365 and the date picker tool is no longer available.

[MuhammadShahAlam]

Suppose, we took another column (Remarks column) and took a TextBox. After selecting 8-9 data from the ListBox, whatever I write in the textbox will be added to that column.