I know we can randomally generate #s in excel VBA, but I
want to randomally select between text values.

Example if A1=Yes A2=No and A3=Maybe

I want a code that only looks at thses values and displays
one in cell B2. If I use the Randbetween formula function
I get the #Value error. because the formula is looking for
#'s

Is this possible?
Pete

Hardcoded:-

=CHOOSE(RANDBETWEEN(1,3),"Yes","No","Maybe")

Referenced:-

=CHOOSE(RANDBETWEEN(1,3),A1,B1,C1)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Pete" wrote in message
...
I know we can randomally generate #s in excel VBA, but I
want to randomally select between text values.

Example if A1=Yes A2=No and A3=Maybe

I want a code that only looks at thses values and displays
one in cell B2. If I use the Randbetween formula function
I get the #Value error. because the formula is looking for
#'s

Is this possible?
Pete


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.576 / Virus Database: 365 - Release Date: 30/01/2004