Find macro

[Guest]

Hello,

I would like to assign a macro to a button which opens the "find" box, but
stops there. Ie, I want the user to enter the data they wish to find. I've
tried the following code from a previous question about this but although it
brings up the find box, whatever I search for always returns no results.
(Doing the seach manually works fine).

Application.Dialogs(xlDialogFormulaFind).Show

Am I putting this in the wrong place? Should there be extra code? I'm using
a Mac, by the way... perhaps there is a way to send the keys "Apple+f"?

Cheers,

Rich.

 

[Tom Ogilvy]

Activesheet.Cells.Select
Application.Dialogs(xlDialogFormulaFind).Show


or select a specific range you want to search

Columns(3).Select
Application.Dialogs(xlDialogFormulaFind).Show

 

[Guest]

Excellent, all sorted!

Thanks,

Rich.

Activesheet.Cells.Select
Application.Dialogs(xlDialogFormulaFind).Show


or select a specific range you want to search

Columns(3).Select
Application.Dialogs(xlDialogFormulaFind).Show