Setting the selected row in a 2-column combobox on a userform

My spreadsheet has a userform containing a two-column combo box. The second column of the row selected by the user is copied to the spreadsheet quite easily with:

Please Login or Register  to view this content.

But how do I do the reverse? If a choice already exists on the spreadsheet I want to pre-select that row of the combo box on the user form when it loads, but:

Please Login or Register  to view this content.

doesn't work. Do I have to iterate through the box until I've matched the cell value?

You should be able to set the value

Please Login or Register  to view this content.

If the matching value is not the bound column then yes you will need to loop through and compare.