title: Popup message if empty cell is found in a row
body: <p>This particular Excel is to be in a shared folder for team members to fill.</p>
  
  <p><img src="https://i.stack.imgur.com/qOsqz.png" alt="enter image description here"></p>
  
  <p>I want to popup an error message before saving. The requirements are:</p>
  
  <ol>
  <li>In a row, the highlighted columns must be filled (error message before save if not filled).</li>
  <li>Select the empty cell to be filled.</li>
  <li>If more than one mandatory cell is empty, select the first one.</li>
  <li>No action for other columns (Non-Highlighted).</li>
  </ol>
  
  <p><img src="https://i.stack.imgur.com/xgoyq.png" alt="enter image description here"></p>
  
  <p>Following is the code I tried. It gives me empty cells in 1st column only. How do I extend it to multiple columns?</p>
  
  <pre><code>Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
      Dim sourceCol As Integer, rowCount As Integer, currentRow As Integer
      Dim currentRowValue As String
  
      sourceCol = 1   
      rowCount = Cells(Rows.Count, sourceCol).End(xlUp).Row
  
      For currentRow = 1 To rowCount
          currentRowValue = Cells(currentRow, sourceCol).Value
          If IsEmpty(currentRowValue) Or currentRowValue = "" Then
              Cells(currentRow, sourceCol).Select
              Exit For 
          End If
  
  
  
  End Sub
  </code></pre>
  
  <p>I'm fresher in VBA.</p>