I have a form with 3 MSHFlexgrid. Each grid are populated.
On the side, i have 2 combobox, one to select what MSHFlexgrid i want to search in, the second if the header column name.
Then, i have the Search value I want to search for and then, the replace Textbox with what i want to replace the value with.
So far, i was using this below code, but this is only for hard coded MSHFlexgrid and column.
I can i update it to adjust based on the the 2 combobox
Private Sub replace_value_Click()
Dim i As Long
Dim LastRow As Long
Dim Found As Boolean
If Len(Trim(search.Text)) = 0 Then Exit Sub
For i = 1 To MSHFlexGrid1.Rows - 1
If search.Text = Mid(MSHFlexGrid1.TextMatrix(i, 2), 1, Len(Trim(search.Text))) Then
LastRow = i
Found = True
If Found = True Then
MSHFlexGrid1.TextMatrix(i, 2) = replace.Text