title: How can I extract a unique 5-digit number from a string using a VBA Regex in Excel?
body: <p>I have series of strings of the following nature in Excel</p>
  
  <pre><code>/item/index/offid/77203/uSasdf/ASFDFAS/catId/401/subCat/709
  </code></pre>
  
  <p>Each string contains multiple numbers separated by backslashes. One of these numbers, however, is a unique 5 digit number, and each string will contain only once such 5 digit identifier. </p>
  
  <p>I'd like my VB based macro to pull out that 5 digit number from each string.</p>
  
  <p>The unique IDs I'm looking for can be either 5 or 6 characters. It is always the first number in the string and I know that the unique ID has terminated once I reach the preceding backslash.</p>