When I want to highlight a whole bunch of rows in an MSFlexGrid, I like to use the Right Mouse Button, so I use this code. However, if you prefer using the Left Mouse Button, then just modify this accordingly.
VB Code:
  1. Private Sub MSFlexGrid1_MouseDown(Button As Integer, Shift As Integer, x As Single, y As Single)
  2. If Button = vbRightButton Then
  3.      With MSFlexGrid1
  4.         .Row = .MouseRow
  5.         .Col = .MouseCol
  6.      End With
  7. End If
  8. End Sub
  9.  
  10. Private Sub MSFlexGrid1_MouseMove(Button As Integer, Shift As Integer, x As Single, y As Single)
  11. If Button = vbRightButton Then
  12.        With MSFlexGrid1
  13.          .ColSel = .MouseCol
  14.          .RowSel = .MouseRow
  15.        End With
  16. End If
  17. End Sub