It depends how the comboBox is populated. If it is populated from a named
range on the worksheet (say, it is called MyRange) then you could use
something like:
MyRange.offset (cboMyBox.ListIndex,0)
ListIndex gives the position in the list of the selected item starting from 0.
This assumes the range is a vertical range.