Randbetween function embedded in a macro HELP

[CuriousG]

Hello everyone, I wonder if there is anyone who can help me please.

From a list of 10 names manually inserted in a spreadsheet I want to invoke a macro by pressing a button (I know how to do this bit). The macro will then randomly a number using the RANDBETWEEN function and highlight the corresponding name in the spreadsheet (this is the bit I don't know how to do).



Ideally I'd like the random selection to be relatively evenly spread across the 10 names but don't know if this is possible to control using a random function.