This fails on one of the OPs criteria, namely that he can dynamically add to
the list of words, so it should be changed to

=OFFSET(Sheet2!A1,INT(RAND()*COUNTA(Sheet2!A:A)),0 )

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

wrote in message
...
Here's how you do it with no macro at all:

Write down the names in Sheet2 from Cell A1 below.

In Cell A1 in Sheet1, type the formula:

=OFFSET(Sheet2!A1,INT(RAND()*10),0)

Remember to change the number 3 in formula with the number
of total names (this is for 10 names).

Every time you press F9 (Excel re-calculates), a different
random name will appear in cell A1,Sheet1.

-----Original Message-----
I am studying for a new course and i want to use excel to
help me with
my study. my objective is to create a button on sheet
one. when i press
this button it should come up with a word and display
this word in a
designated cell. this word has to be selected RANDOM from
a list in
sheet two. everytime I press the button it should come up
with a new
word (totaly random). I also have to be able to update
the list with
new words. can somebody please help me with a formula or
a VB script
??? please, this is very urgent.
thanx

oscar


---
Message posted from http://www.ExcelForum.com/

.