View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bartman1980 bartman1980 is offline
external usenet poster
 
Posts: 34
Default Search and select a cell when pressing enter

I want to make a some kind of CTRL-F field in my sheet.

If the text (or a part of the text) in cell F1 is found in row A then
select the cell with the text where it was found.
And when I'm in the cell F1, I prefer just to press 'enter' instead of
clicking on a button.

Does somebody have an example?