I am looking for VBA code that will set the default value to "Current Field" (Look In) in the Find/Replace Dialog Box. I have attempted using "SendKeys" which works to default to "Any Part of Field" (Match), but SendKeys will not work for the "Look In" field. My end goal is to click in the desired form field to search, click a button, and have the Find/Replace Dialog Box pop-up and have the "Look In" field default to "Current Field" and have the "Match" field default to "Any Part of Field." Any help in this endevour would be greatly appreciated.
Thank you