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