At work I've got a mileage chart with distances between around 90 resorts.
I've already got a userform set up to retrieve the distance between 2
selected resorts. What I'd like to add is the ability to list at the bottom
of the user box the ten closest resorts to the first chosen resort.

Logic says that I would have to pull a list of all of the distances from the
chosen resort, sort it, then get the top ten onto the userform. Although, I
haven't been able to get anything to work yet.

Your help is much appreciated.