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