Formulas cannot call a macro, you could actually have a macro attached to the
worksheet_change() event to monitor a column or fixed range as your A5:A238
range and notify the user, clear the entry and select the cell the previous
entry is in.

Or would you prefer to call the macro 'manually' after the alert is put up?
In any case we need a little more information like: is A5:A238 always the
range to be examined for prior entry? Is A7 always then cell that they enter
a number into? If not, describe it all in a little more detail please.

Also, it's a little confusing that you're testing A7 within the range
A5:A238??

"Malcolm McM" wrote:

I have a list using unique coded ref numbers.
During the data entry process, if the unique code has already been entered,
I use this statement "=1=COUNTIF($A$5:$A$238,A7)" to warn the operator that
it has already been entered and to display the cell ref where it is located.
I would like to create a macro that will locate the record once the warning
is activated.
Any help would be appreciated.