The hat is empty (no tricks in it...)

 

Maybe you need to approach this another way. FocusChange event of RC is fired when using arrow / page-up / page-down keys.

 

You could use this FocusChange event to determine if last row is selected:

 

If wndReportControl.Rows.Count = NewRow.Index + 1 Then "Do Something"

 

If you would use wndReportControl.Navigator.MoveLastVisibleRow in VScroll_Change event the FocusChange event will be fired everytime the user clicks on scrollbar buttons. But this doesn't work correct, CJ developers. Only when scrolling to the top works correct. Scrolling down it doesn't select last visible row

 

 

 

 

 

Hi,

 

Value of VerticalScroll will always be number of rows MINUS number of visible rows. To determine how many rows are in the visible portion of RC:

 

Dim firstRow As Long
Dim lastRow As Long

Dim numberOfVisibleRows as long

wndReportControl.Navigator.MoveFirstVisibleRow
firstRow = wndReportControl.FocusedRow.Index
wndReportControl.Navigator.MoveLastVisibleRow
lastRow = wndReportControl.FocusedRow.Index

 

So:

 

numberOfVisibleRows = lastRow - firstrow

 

So:

 

If wndReportControlData.Rows.Count = (VScroll.Value + 1) + numberOfVisibleRows  Then "Do Something"

 

 

 

Do you use SetScrollBars method to attach it ?