Ctrl+F

[Clueless401]

Hello Everyone,

You all are amazing! i want to thank anyone and everyone for the help on learning Excel. I am quickly becoming a big fan of this.

Is it possible to create a Ctrl+F search bar on my work sheet. I am trying to locate key items fast if possible.

Thank you

 

[BobUmlas]

If by "Ctrl+F search bar" you mean a button, you can assign this to that button:
Sub CtrlF()
Application.Dialogs(xlDialogFormulaFind).Show
End Sub

But I don't see that being any faster than Ctrl+f. Can you further describe what you mean by Ctrl+F search bar?

 

[Clueless401]

If by "Ctrl+F search bar" you mean a button, you can assign this to that button:
Sub CtrlF()
Application.Dialogs(xlDialogFormulaFind).Show
End Sub

But I don't see that being any faster than Ctrl+f. Can you further describe what you mean by Ctrl+F search bar?

Yes a button. pretty much need to make it user friendly so anyone can search for an item in stock, same way that you would use a search feature on any website. does this make sense?

 

[BobUmlas]

then, like I said, assign the button to this procedure:

Sub CtrlF()
Application.Dialogs(xlDialogFormulaFind).Show
End Sub

 

[Clueless401]

then, like I said, assign the button to this procedure:

Sub CtrlF()
Application.Dialogs(xlDialogFormulaFind).Show
End Sub

i really dont know how to do that yet. Im very new to excel, when i say new i mean behind very behind

 

[jasonb75]

Is it possible to create a Ctrl+F search bar on my work sheet.

This comes to mind based on the way you have phrased your question.

Create an Excel Drop Down List with Search Suggestions

Learn how to create an Excel drop down that shows suggestions as you type. A step-by-step tutorial to create an Excel Drop Down List with Search Suggestions

trumpexcel.com