title: Checking multiple textboxes/comboboxes for input
body: <p>I have a userform with multiple comboboxes and textboxes that I use to input data to the worksheet. What I have been looking for is a code that will check all of these boxes before saving the data to the worksheet, so if one is empty it will pop up a message and not save the data.</p>
  
  <p>I have been using a function that checks each one individually but it'll still save data to the sheet if the others are blank.</p>
  
  <pre><code>Public Function CheckEmpty(text_box As Object) As Boolean
  CheckEmpty = (Len(Trim(text_box.Value)) &gt; 0)
  End Function
  </code></pre>