The ListIndex of a combobox(or listbox) is the tells you which item has been selected.

It's starts at 0, so if the 1st item is selected the ListIndex is 0, if the 2nd item is selected it's 1, the 3rd its 2 and so on.

So to get the row number of the selected item we need to add to the ListIndex.

What to add depends on how you've populated your combobox, in particular which row you've started from.

For example if you've populated using A1:A10 then you need to add 1 to the ListIndex to get the row, if it's was A2:A11 you would add 2 and so on.

Hope that explains a bit, and sorry about the mistakes.