title: How to clear search conditions and word after a search using Excel VBA
body: <p><strong>Scenario</strong></p>
  
  <p>I have a userform whereby a button on it doing search function with MatchCase = True in addition to other automated works. Whenever this userform is active and I try to do some search in other opened worbooks, always Match Case is ticked. Everytime I need to manually uncheck the Match case in excel while this userform is active. Please see the pictures</p>
  
  <p><strong>When userform is not showing</strong></p>
  
  <p><a href="https://i.stack.imgur.com/hCh6s.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hCh6s.jpg" alt="enter image description here"></a></p>
  
  <p><strong>When userform is showing</strong></p>
  
  <p><a href="https://i.stack.imgur.com/GlRF5.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/GlRF5.jpg" alt="enter image description here"></a></p>
  
  <p><strong>Question</strong></p>
  
  <p>Is there any way that I can run my macro with MatchCase = True but at the same time when I open other workbooks and press Ctrl+F Matchcase by default unchecked? In other words how to remove the search keyword and search condition after a search macro execution? I am using the following search codes with search word as a variable <code>worD</code></p>
  
  <pre><code>Selection.Find(What:=worD, After:=ActiveCell, LookIn:=xlFormulas, _
  LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
  MatchCase:=True, SearchFormat:=False).Activate
  </code></pre>