DataGridView - Capture Changed SelectedIndex Of Combobox

I have a DataGridView on a windows form.

The 4th column is a combo box column.

Now what I want to do is capture the event every time a value is changed in the combo box drop down (selectedindexchanged). When the index is changed, I want to grab the row number, and then I will grab the value of the now selectedindex and do some database updates with it.

I currently have tried to put together an event grabber when the combo box is changed, however it doesn't work correctly.

My code is:

Private Sub dgvRooms_EditingControlShowing(ByVal sender As Object, _
ByVal e As DataGridViewEditingControlShowingEventArgs) _
Handles dgvRooms.EditingControlShowing

[Code].....

I put in a message box to check that it was capturing the event. I then noticed that it captures it more than once when you change the value.

The problem is when I go to click the down arrow on the row, the event is run once (message box show). Then you have to click a second time (event is run again with message box) before it shows the drop down list.

Then when you click on the value you wish in the drop down box it shows the message box (the only time I want it to run).

Then when I leave that row, it shows the message box two more times.

Effectively it goes to update the data 5 times, I only want to do it once.

I can not there is a pencil editing icon when you click on a row to the far left, and it appears when you leave the row, after already clicking on your value, it then checks on row leave that the values havn't changed, hence it runs two more times.

How do I make it so it only runs once on the value being changed?

Is there a way to disable the pencil editing, but still enable the combo box column to work? (be clickable and choose an option)