I want to create a macro that opens the find box in excel and then I can type
in anything I want to find. I don't want to use the edit find to open this
box in excel. I have tried recording a macro to do this but when I rerun the
macro it doesn't open the find box or if it does it doesn't stay open for me
to type in the number I want to find. The number I want to find will always
be different so I can't write that number into the macro, can anyone ghelp me
with this please

Application.Dialogs(xlDialogFormulaFind).Show
--
HTH...

Jim Thomlinson


"Ken" wrote:

I want to create a macro that opens the find box in excel and then I can type
in anything I want to find. I don't want to use the edit find to open this
box in excel. I have tried recording a macro to do this but when I rerun the
macro it doesn't open the find box or if it does it doesn't stay open for me
to type in the number I want to find. The number I want to find will always
be different so I can't write that number into the macro, can anyone ghelp me
with this please

hi
this is the vb code to show the find dialog box.....
Application.Dialogs(xlDialogFormulaFind).Show

how ever, there is an icon to do this already(binoculars) and a keyboard
short(alt+F) so i see little to gain it creating a special macro to do what
is already built it.
but..... if you want it.....
Regards
FST1
"Ken" wrote:

I want to create a macro that opens the find box in excel and then I can type
in anything I want to find. I don't want to use the edit find to open this
box in excel. I have tried recording a macro to do this but when I rerun the
macro it doesn't open the find box or if it does it doesn't stay open for me
to type in the number I want to find. The number I want to find will always
be different so I can't write that number into the macro, can anyone ghelp me
with this please