I had a look at the page you showed, too much for me to look at right now, managed to record creating a list and this alone has given me a solution...
in vba when you redefine a list it shows the current list before deleting it and creating a new one even if it's the same. Using this information I can add the current cell contents to a new redefined list. I'll post the finished code in the morning as I'm not at work, and my vba cade already has a lot of dynamic addressing involved that i intend to make use of in this, so I can use the same vba macro for updatating any list with the currently selected cell, if it has a dropdown list to select from my code will update that list.

regards
Trevor

And thanks for your input, I did get some extra ideas from there as well.