Need help with a random vba routine, implmenting dynamic ranges and copying last line

[reddwarf]

Hi Group,
I am going back to study French and, after being out for a few years, I came up with a French revision spreadsheet to help me learn the basics. Scaled down example spreadsheet attached. I have taken it this far (mainly using code grabbed from other internet sources) but really need help to tweak it to make it work better.

Can someone help/show me how to:

1) change the code behind the random button to select a different random cell because it always selects the same random cell in the same order every time I re-open the document? Also, can the code be updated to select a cell within the used range (ColD), making it dynamic, so whenever I add a new line it picks up that new line for the random routine.

2) Can someone give me code which will copy the last line down, including formulas, to enable me to make a new entry?

2) I use keyboard strokes such as Alt+0234 to type a 'ê' but is there anyway of adding a button and code to do the same when I am typing in a cell?

Any other suggestions for improvements would be most welcome

Many thanks

[antoka05]

See attached file, I hope it can help you.

Regards,
Antonio

[reddwarf]

Excellent Antonio,
It's working great.
Thank you very much