Hi,

I creaed a function that chooses a random alphabetical character (from A to
Z), comparable to the built-in Rand function.
My function neither doesn't take any arguments.
One of the sympathetic uses of Rand or Randbetween is that it recalculates
automatically when pressing F9 or when pressing Enter or OK.
I would like to have that same kind of volatility to my RandCharacter
function.

Is this possible?

Anybody got any ideas?


Any help is greatly appreciated.


Sybolt

At the top of the function add the line

Application.volatile
--
HTH...

Jim Thomlinson


"sybmathics" wrote:

Hi,

I creaed a function that chooses a random alphabetical character (from A to
Z), comparable to the built-in Rand function.
My function neither doesn't take any arguments.
One of the sympathetic uses of Rand or Randbetween is that it recalculates
automatically when pressing F9 or when pressing Enter or OK.
I would like to have that same kind of volatility to my RandCharacter
function.

Is this possible?

Anybody got any ideas?


Any help is greatly appreciated.


Sybolt

Yes Jim.

It works.

And I also managed to call for another used-defined function in my new
user-defined function.
Now it's Volatility all round.

This really helps in creating random examples or excersizes.

Great.

With great power comes great responsibility. Volatile functions are a drain
on resources so use them judiciously...
--
HTH...

Jim Thomlinson


"sybmathics" wrote:

Yes Jim.

It works.

And I also managed to call for another used-defined function in my new
user-defined function.
Now it's Volatility all round.

This really helps in creating random examples or excersizes.

Great.