Excel button to randomly select from list

[shineres]

Hi,

I have a list of names in column A and placed a button between columns B-D. How do i make it so that when i click the button it will randomly select from column A and list on Cell B5.

[dohvakin123]

assign it a macro:

Sub choose()

Dim row As Integer

'this range in the brackets should be the first and last row of your list on column A
row = WorksheetFunction.RandBetween(2, 10)

ActiveSheet.Range("B5") = Range("A" & row)

End Sub

[shineres]

That works Thank you!!!

[dohvakin123]

change the part in RandBetween, i.e. "RandBetween(first row, last row)"
then keep the rest as it was originally

[dohvakin123]

That works Thank you!!!

if you could add reputation i would appreciate it (star button on bottom left)