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.

[Purfleet]

Try something like this

Sub Randomly_generate_a_number_between_1_and_10_inclusive()
'
' Macro1 Macro

    Range("b:b").Interior.Color = xlNone
    
    randnum = WorksheetFunction.RandBetween(1, 10)
'
    Range("D2") = randnum
    
    Range("A:A").Find(what:=randnum, LookIn:=xlValues, lookat:=xlWhole).Offset(0, 1).Interior.Color = vbYellow
       
    
End Sub

[p45cal]

Mixed messages in your file (button text) and the narrative in msg#1!
In the attached 3 buttons doing various things, each calling a one-line macro, along with some conditional formatting on the sheet. More explanations in the attached.

[CuriousG]

OK guys thanks very much for your help