Why not just use Edit - Find (Ctrl + F).
--
HTH...

Jim Thomlinson


"danw" wrote:

I am trying to write a macro that will allow a user to type in text into a
"FIND" field after the macro is executed. It will need only to locate the
first case in a spreasheet.