title: vba excel - find string wildcard
body: <p>I am doing a simple search engine in excel and I want to make some wildcards, for example:</p>
  
  <p>I have a cell where the user input the search term (only numbers) which should look like this: "123456".
  then, I have another workbook, where I search for the "123456" exactly. this I managed to do.</p>
  
  <p>however, how can I make wildcards? for example, I want the user to be able to search for: "123?56" and I will give him the results of: "123456", "123356", "123556" etc.</p>
  
  <p>this is how I look for the exact match:</p>
  
  <pre><code>set rFound = wks.UserRange.Find(strToSearch, LookIn:=xlValues, lookat:=xlwhole, MatchCase:=False)
  </code></pre>
  
  <p>any ideas?</p>
  
  <p>thank you</p>