nascarjeff
New Member
- Joined
- Jan 19, 2004
- Messages
- 10
I am trying to do a search for specific text. That part seems to work in the code below. What i would like to also return is the row & column where the info was found.
Thanks in Advance,
Jeff
Dim FindSelection as Variant
Dim SearchArray as Variant
SearchArray = Selection.value
For Each FindSelection In SearchArray
If Label1 = FindSelection Then 'Label1 = user selection from a list box
MsgBox "Found it"
End If
Next
Thanks in Advance,
Jeff
Dim FindSelection as Variant
Dim SearchArray as Variant
SearchArray = Selection.value
For Each FindSelection In SearchArray
If Label1 = FindSelection Then 'Label1 = user selection from a list box
MsgBox "Found it"
End If
Next