Re: £25 - Creating a Userform
Quote from KjBox;752642
OK I have found a way to use random selection of referees without too much re-work.
In the attached file the data validation for referee selection has been removed and now, when a cell in either of the 2 referee columns is clicked, a referee is randomly selected from the list of all referees. The same checks are performed on that selection as were done when the referee was manually selected, and the same messages and options to accept or not are shown if appropriate. If a referee is selected for either first or second choice after the other choice has been made and the randomly selected name is the same then a new random selection takes place automatically.
To change an already selected referee click on that name and a message will show to confirm that a new randomly selected referee is to replace the current referee.
I really appreciate your efforts.
I'll play around with it and I'll get back to you in the next 48 hours!
Got a few things to do first!