Drop Down used to find and select sections

I have a drop-down which is used to automatically go to a selected section in the worksheet. In this example I have Section 1, Section 2, Section 3, etc.
It works quite well. There is just one part which I want to improve.
Let's say I last selected Section 3, then later on I am in a different part of the workbook. I then select the same Section 3. It doesn't work. It only works if the selection is different to the last one (anything other than Section 3).

Notes on Drop Down:
The mechanics are better explained by viewing the attached workbook.
The input data is saved a part of the worksheet coloured yellow. There is a section list, the selection made and the index of the selection. All 3 parts are given names.
The drop down then has the following parameters: Right-click, Input tab ... Input range = the selection list, Cell link = index of the selection.


Assigned macro to drop-down

Please Login or Register  to view this content.

@AlphaFrog:
Thanks for solving this.
I was hoping the current selection remained in the drop-down ... but in thinking about it, I don't think it would be possible, would you agree?
Otherwise I don't think it can be taken further.
Thanks.

Thx once more.
Works as intended.

AlphaFrog, I've been using your code for a while now and it works really well.

To summarise, the drop down is used to go to a selected section in the worksheet by using "Find".
The default way it worked was that if a selection is made (say "48 Section"), then if the same selection is made later on, it doesn't go that that cell. This may be because a change is required to make the macro run.
The new method clears the selection and you can now go to the same selection later on.
More info in original post.

With the new method, if there are a lot of sections, it goes back to the start.

Would it be possible to keep some of the functionality from the original method. See attachment.

1. Start on previous section for next choice.
2. Highlight previous choice.

Untitled.png