-
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
-
if the flex grid is called fgTemp
fgTemp.Row = the active row (ie the last row the user selected)
fgTemp.Col = the active col
these properties can also be set in code if needed
private sub fgTemp_Click()
if blnEditRow then
call editRow(fgTemp.Row)
else
call editCol(fgTemp.Col)
end if
end sub
