title: VB.NET datagrid - detect combo box selection and select same value in different column
body: <p>I have a datagrid with combo boxes. Now I want to achieve that if on selects value x in column 0 row 0 then then combo box value y in colum 1 row 0 is set to the same value like x automatically.</p>
  
  <p>I tried </p>
  
  <pre><code> Private Sub dataGridView1_CellValidating(ByVal sender As Object, ByVal e As DataGridViewCellValidatingEventArgs) Handles Sched_Grid.CellValidating
      If Sched_Grid.CurrentCell.ColumnIndex = 0 Then
          Sched_Grid(1, Sched_Grid.CurrentCell.RowIndex).Value = Sched_Grid(0, Sched_Grid.CurrentCell.RowIndex).Value
      End If
  End Sub
  </code></pre>
  
  <p>However, it doesnt work immediately. I have to first selected a value x(0,0), then click a different cell(5,5 or something else) and then click back into x(0,0) cell so that y(1,0) gets set to x(0,0).</p>
  
  <p>How can this be solved?</p>