title: Is it possible to not allow null values for particular in an excel data entry spreadsheet (VBA?)?
body: <p>I have an excel worksheet where I have a number of manual data entry and calculated columns, which is to be filled in line by line with the rows filled from left to right.</p>
  
  <p>I have a few columns which I want to ensure are not left blank as this data entry is carried out. </p>
  
  <p>E.g.
  <a href="https://i.stack.imgur.com/vzEBu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vzEBu.png" alt="Example data entry sheet"></a></p>
  
  <p>Here I am entering data from left to right on the 3rd row and want to ensure that if the person doing the data entry manually accidentally skips the "Unique ID" column and tries to fill in "Type" first, they will be forced back to the "Unique ID" cell or at least experience a pop-up to tell them to enter in "Unique ID" first.</p>
  
  <p>Is this something that can be done?</p>