how to trigger the "find" popup box on Mac Excel

[anxoperez]

I would like to have a macro that selects Columns G-L and then triggers the find searchbox. I tried this with sendkeys but it didn't work (used to work on my PC).

Can someone help?

 

[shg]

Maybe ...

Sub x()
    Columns("G:L").Select
    Application.Dialogs(xlDialogFormulaFind).Show
End Sub

 

[anxoperez]

I can't believe I wasted almost an hour to try to figure it out on my own (when I have no clue about programming) when I could have asked you guys.

IT WORKED!

Long live TX

 

[anxoperez]

One more thing:

I need to add a feature to the search.

I need to search not within formulas but within values. Can someone tell me how to add that bit of code to the rest?

Thanks

 

[RoryA]

Don't know about Mac Excel but in Windows:

Sub x()
    Columns("G:L").Select
    Application.Dialogs(xlDialogFormulaFind).Show , 2
End Sub

 

[anxoperez]

perfecto!