Find Formula

  • Thread starter Thread starter CHARLENE
  • Start date Start date
C

CHARLENE

Please help,

I am trying to enter a formula that will find whatever is typed in within
selected cells.

Example: I want the user to be able to type a name or number into a cell and
they will be taken to the location of that cell like with the Find Function
but without having to use that function.

is there a formula to do this?

Many thanks
Charlene
NZ
 
A formula can't actually move the cursor to another cell - a formula
can only return values. You will need some VBA code to do that.

You could think about using hyperlinks. For example, enter a number
into A1 and then click on B1 where a hyperlink formula will enable you
to jump to the cell indicated by A1 - would this be of interest?

Pete
 
Formulas ONLY return values. You will need a macro to do this. A
worksheet_change event in the sheet code module using vba FIND should be
ideal.
 
Back
Top