I am trying to give the user the option to edit the fixed columns or rows based on if they click on a col. or row they want to change. I am unable to get it to work. does anyone have any ideas. I am trying to load a form that lets the user type in a new name for a column or row and save it and update it. Below is the code I tried and cannot find the column or row the user clicks on.


Private Sub MSFlexGrid1_MouseDown(Button As Integer, Shift As Integer, x As Single, y As Single)
Dim iRow As Integer
Dim iColumn As Integer
With MSFlexGrid1
iRow = .MouseRow
iColumn = .MouseCol
If .TextMatrix(iRow, iColumn) = "Header1" Then
frmEditCell.txtInput = .TextMatrix(.MouseRow, .MouseCol)
frmEditCell.Show
End If
End With
End Sub