I maybe going about this in the wrong way... Help

  • Thread starter Thread starter Neil Ensor
  • Start date Start date
N

Neil Ensor

Using text input in a form I need to search through a vertical list in a
column until I have identified the row I want. I need to minimise
keystrokes to make this an effective method.

Once I have identified the row I want I then need to activate the cell
so I can apply some editing from my form with an offset. I tried using a
filter but I think now i was going about this in the wrong way.

Any thoughts...??
Rgds
Neil

*****Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum & Business Software*****
 
How about using find:

dim FoundCell as range
with activesheet.range("e:e")
set foundcell = .cells.find(what:="whatever", _
after:=.cells(.cells.count), ......)
if foundcell is nothing then
msgbox "not found"
else
with foundcell.offset(0,-3)
'do your stuff
end with
end if
end with

If you record a macro when you do the find that you want, it'll be easier to
build that .find statement.
 
Thanks v-much for the reply...

I think I need something else as Idealy I dont want to have to key in
the entire word or sentance into the search. I need a method that will
whittle down the results on each keystroke of entry into the search
until it returns only the row in question. from there I do my offset
edit.

Minimising keystrokes is the objective of this programe.

Any thoughts...??

Rgds
Neil

*****Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum & Business Software*****
 
Dave.... You beauty.

With a little tweaking I got your code to work with mine..

Thanks very much
Neil

*****Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum & Business Software*****
 
Back
Top