Excel Search Engine Formula that simulates Control F, Option, Within Workbook, Find All

[Candy Samsung]

Excel Search Engine Formula that simulates Control F, Option, Within Workbook, Find All

 

[RickXL]

Hi,

Are you looking for this:

Sub myFind()
    Application.CommandBars.FindControl(ID:=1849).Execute
End Sub

 

[Candy Samsung]

Hi,

Are you looking for this:

Sub myFind()
    Application.CommandBars.FindControl(ID:=1849).Execute
End Sub

Is this a VB code thing? I'm completely illiterate with code stuff. I took a class once, but I have forgotten everything since. Are you saying the only way I can get desired results is to to a VB code thing? I'll try if you say its only way. I may ask more questions if you say yes.

 

[RickXL]

Hi,

If you go into the VB Editor, select Insert-->Module and paste that code in then if you hit the F5 key it will run it for you. You could link that macro to a button on the worksheet - or an option on the menu bar but there already is one there.

From your question, I am not quite sure what you were expecting. What is wrong with the ordinary Find command? What are you expecting on top of that?

If you use VBA there are other ways of finding things.
If you don't want to use VBA there is the Find command in the Editing menu.

 

[Candy Samsung]

I like your macro, but how do I link it to a button on the workbook. I'm trying to make this as simple as possible for my coworkers when researching. Our project is coming to an end soon, this is clean up now.

Oh, I got the button inserted... now I'm trying to make the button bigger and change name.

I LIKE THIS!!! Thank you!