Creating sinle random letter - code not working

Before you call the Rnd function add the line of code:

Randomize Timer

To set the seed for the random number generator.

Lovely thank you Andrew.

It works, however, I've noticed that occassionally it is generating the [ character. What am I doing wrong?

Also, do I need to use the statement Randomise Timer each time I'm about to perform the RND command?

The "[" character is ASCII code 91, so you're overshooting your intended range by 1. This is because the CInt function rounds to get an integer value, so it can round the result of Rnd() * 26 up to 26, which you don't want.

Try using:

a = Chr(Int(Rnd * 26) + 65)

As for the randomize function - generating random numbers is very tricky for a computer, so what the Rnd function gives you is the next number in a mathematical sequence defined by some complex formula. The initial value that is fed into this formula (the seed) can be set using the Randomize function, and using the timer function (which returns fractional number of seconds that have elapsed since midnight) makes it unlikely that the seed will be set to the same value every time the code is run.

Normally you'd just call randomize at the start of a function or sub using Rnd, but if you'd like to call it more often then that's up to you.

Thanks Andrew. It works perfectly. And thanks for explaining how randomization is made. It's all a lot clearer to me now!

Jerry thanks also.