I want to create a macro that opens the Find Box on the sheet

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to generate powerpoint slides 43
How to force macros refer to ActiveWorkbook 2
Using macros to open a file with the Find Menu option available 5
Macro to Combine Data from Multiple Sheets with Cell References 4
Unwanted workbooks on startup 2
How to store values in excel using macro ? 4
How do i find the text box number? 2
Opening a list of Excel files and run a macro in each 17

Back
Top