Tired of reformatting ctrl f to find something

[flpunt]

I need to search for items in a column and use Find but I have to change the format by clicking the "Options" & the Match Case & Match entire cell contents and the search in columns.
It's annoying to have to keep doing this. Is there a way of creating some kind of shortcut or saving the find selections?

 

[Caribeiro77]

You could create a macro an assign a shortcut...

 

[flpunt]

I tried a simple macro and recorded the key strokes but it wouldn't run.

 

[MUKESHY12390]

perhaps this....

Sub Find_value()


Dim SearchMe As Variant
SearchMe = InputBox("Enter Value")


On Error GoTo msgbx
Set found_value = Cells.Find(What:=SearchMe, After:=ActiveCell, LookAt:=xlWhole, MatchCase:=True)
found_value.Activate
exit sub

msgbx:
MsgBox "not found"


''Put shortcut that will help"
End Sub

 

[flpunt]

Sorry I'm not familiar how to program this?

 

[XLWiz]

Not sure if you received a response to this, but all you needed to do was enter Alt+F11 to open VBA to paste in the code MUKESHY12390 provided for you. Copy the code, right-click on your workbook and insert it in the "module" option. Replace the portion inside the quotes that says "put shortcut that will help" with any key combination you'd like to designate as your shortcut. Save your worksheet as macro-enabled and enter ALT+Q to close VBA. You can run the code by entering ALT+F8. Select the macro you created, and click run.