I want to have a listbox showing a selection of names and when a name is selected the cursor should "jump" to a specific location on the same sheet. A sort of hyperlink in a dropdown list! Can anyone help.
Thanks for responding Erik.
Listbox will be populated from a single column. Once a selection has been made from the listbox the cursor should goto the named cell. eg. Should I select Brussel from the list then the cursor should goto the named cell Brussel on another sheet. Hopefully this is clear.