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 Exit Sub Else End If End If NextEnd Sub