I am trying to create a function in excel to randomly select a value which will then go into a combo box when I click on a button and will then take that value so I can add it to another spread sheet.
On my second spreadsheet I have a list of values which I am trying use.
I know that in excel you can use the random function like this ?
=INDEX(Sheet2!$C:$C,RANDBETWEEN(1,COUNTA($C:$C)),1) . but how would I include this function into a combo box as this appears blank if I type it into the properties box of the combo box