title: EXCEL VBA Check if entry is empty or not 'space'
body: <p><strong>Note.</strong> Check if the <code>TextBox1</code> is empty is easy by using <code>TextBox1.Value = ""</code>. </p>
  
  <p>But the problem is when the user hit the <code>spacebar</code>, <code>TextBox1</code> will still recognize it as a value. In such case, my data will appear as an empty cell with 1 <code>space</code> inside. So my <strong>question</strong> is, is there any method to check <code>TextBox1.value</code> for empty and also not consist of <code>space</code> whether there are 1 or more <code>space</code>? Million thanks to all.</p>