On the attached example, I have a list of football fixtures listed in the range AW4:AW169 and this list is populated in ComboBox1.
What I want to do is add some code so that when a user selects a fixture from the ComboBox (either by choosing with their mouse or searching by typing) then that corresponding row is selected on the worksheet in column B.
So, for example, if I was to select Celtic v Rangers (which is in row 166) then once selected focus on the worksheet should move to cell B166.
Ideally, I don' want to the active cell moving around as I am typing in the combobox if possible. I just think this would be a little irritating. I only want to focus on the value of the ComboBox once selected.