something like a search engine: a textbox and a search button.once key
in the value in the textbox and pressed "search", it will track the
data in the work sheet1 and return the column number and row number in
the other 2 TextBoxes.
Dim cell As Range
With ActiveSheet.Range("a1:a500")
Set cell = .Find(2, LookIn:=xlValues)
If Not cell Is Nothing Then
MsgBox cell.Row & " - " & cell.Column
End If
End With
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
Sure.....but could you explain yourself a little bit better?
something like a search engine: a textbox and a search button.once key
in the value in the textbox and pressed "search", it will track the
data in the work sheet1 and return the column number and row number in
the other 2 TextBoxes.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
