Have UK top of my sheet list then maybe sort other countries as A-Z advice

[ipbr21054]

On my userform i have a Combobox which in its properties Row Souce i see Table5
Table5 on my worksheet shows a list of countried.
The countries are listed A-Z so naturally UK is at the bottom.

Thus when i click in the Combobox i find im scrolling to the bottom of the list the majority of the time.

Can you advise how i can overcome this so maybe example, UK at the top then the rest of the list shown A-Z

Open to any other suggestions.
Thanks

 

[Kaper]

Some kind of custom sort could be a solution, but ... may be as a source you could use a list where instead of
UK
is
UK
so UK proceeded by space.


And the output of combobox could be treated with TRIM function to get rid of this space.

 

[ipbr21054]

Adding a space worked fine Thanks