Thank you for Graham for your reply.


Yes it is part of a userform

Regarding why I used a Listbox was honestly that's all I could think of at that time and just went with it.
On reading the code that you wrote it made it very simple and I adapted it to my userform and it works exactly as it should.
Once again many many thanks.