Unique value on a click

[menyanthe]

Hello,
What I am trying to do is generate a unique value from 1 to 23 each time a user clicks on a button. I used this code for generating random numbers in a list

Please Login or Register  to view this content.

Is it possible to make it so, that on every click to show a different number? (the purpose is to make a random drawing for each person for Christmas presents - person A makes present to person 20 for example, person B to person 14 and so on). The idea is to post the worksheet in google docs or something like that (not sure if google docs supports macros) and then whenever a person enters and clicks the button shows them the number they are supposed to give present to. Then the next person enters and shows them a different number. Is it possible at all?

[Steffen Thomsen]

Then you have to store the values allready created in a range and create a check up against these values

[menyanthe]

This code creates a list (A1 to A23), but how do I make a code to choose each time the value of the corresponding cell and show it?
I mean on the first click it shows A1, on the second A2, on the 23rd A23, on the 24th shows a message or something...
Or maybe a different code that creates one value at a time, then store it and next time make a check if this value is already created?
I am sorry, I am a bit noob in this Thanks