I have an excel sheet that has a combo box populated by a list in a
separate worksheet. The combo box list is based on the first column,
the second column has the description of the item. I would like to put
the description that matches the currently selected item into the
column next to the combobox.

I dont know how to check what record is currently selected or how to
retrieve the row number of the currently selected item

any help would be great