title: Excel VBA code to submit multiple userform data to populate worksheet
body: <p>Super new to coding, please help and please excuse the lack of general knowledge:</p>
  
  <p>Is there a match function equivalent in VBA?</p>
  
  <p>I have a userform that has the following:
   - a combobox to select employee name
   - a comboboc to select project number
   - text box to input hours worked
   - text box to input OT hours worked</p>
  
  <p>On Sheet2 named "Template for Input" I have a sheet that needs to stay in this format:
  Project Numbers going accross in starting in Row B11 and Employee Names listed in vertically starting in ColumnA12.  Each name is duplicated to allow for RegHrs and OTHrs.  </p>
  
  <p>Example:</p>
  
  <pre><code>          Project 1     Project 2   Project 3
  </code></pre>
  
  <p>Doe, Jane</p>
  
  <p>RegHrs  </p>
  
  <hr>
  
  <p>Doe, Jane<br>
  OTHrs</p>
  
  <hr>
  
  <p>Smith, John<br>
  RegHrs</p>
  
  <hr>
  
  <p>Smith, John<br>
  OTHrs</p>
  
  <p>I need my Submit Hours commandbutton in the userform and have the data selected populate the worksheet in the appropriate columns/rows.  For instance if entry is Doe, Jane Project 2, 40 RegHrs 6 OT Hrs.  How do I write the code so when the click submit it populates Jane's hours in the right spot??  </p>
  
  <p>I also would need it to clear the userform so they can input the next employees hours until they are finished and hit close.  </p>
  
  <p>I hope that wasn't too confusing.   I appreciate all of the help~~~</p>