Find & Replace to open different by default

[Uni2023]

I posted this a while back but didn't receive any replies that could help so thought I would try again. I'm essentially VBA dumb so please be kind and very explanatory lol.

Is there a way of getting the Find & Replace (Ctrl F) window to open with Values always displaying in the Look In: field by default?? Advice was you could do it through a UserForm and nominating a shortcut key along with the Ctrl key but I have no idea as to how to do that and Excel help and Googling didn't come up with a lot.

Any help is appreciated

Cheers
Brett

[GC Excel]

Hi uni2023,
you can use the xlDialogFormulFind dialog like this, in a macro :
Then assign a keyboard shortcut to this macro.

Please Login or Register  to view this content.

If you want to use this is ALL your workbooks, you can create and save the macro in a personal workbook
Then assign a keyboard shortcut to it.

Hope this helps !