esta es la imagen solo me selecciona el registro que vale SOS, quiero que me seleccione toda la fila que vale SOS.
este es el codigo, utilizo 2 timer para parpadear la fila que vale SOS
Private Sub Timer4_Timer()
Dim i
Dim j
For i = 1 To flex.Rows - 1
For j = 1 To flex.Cols - 1
flex.Row = i
flex.Col = j
If flex.Text = "SOS" Then
flex.CellBackColor = vbRed
End If
Next j
Next i
Timer4.Enabled = False
Timer5.Enabled = True
Timer2.Enabled = True
End Sub
Private Sub Timer5_Timer()
For s = 1 To flex.Cols - 1
For c = 1 To flex.Rows - 1
flex.Row = c
flex.Col = s
If flex.Text = "SOS" Then
flex.CellBackColor = vbYellow
End If
Next c
Next s
Timer4.Enabled = True
Timer5.Enabled = False
Timer2.Enabled = True
End Sub
este es el codigo, utilizo 2 timer para parpadear la fila que vale SOS
Private Sub Timer4_Timer()
Dim i
Dim j
For i = 1 To flex.Rows - 1
For j = 1 To flex.Cols - 1
flex.Row = i
flex.Col = j
If flex.Text = "SOS" Then
flex.CellBackColor = vbRed
End If
Next j
Next i
Timer4.Enabled = False
Timer5.Enabled = True
Timer2.Enabled = True
End Sub
Private Sub Timer5_Timer()
For s = 1 To flex.Cols - 1
For c = 1 To flex.Rows - 1
flex.Row = c
flex.Col = s
If flex.Text = "SOS" Then
flex.CellBackColor = vbYellow
End If
Next c
Next s
Timer4.Enabled = True
Timer5.Enabled = False
Timer2.Enabled = True
End Sub