you could do this with a userform. I like to use 2 list boxes and an edit box
one list box should hold all the data and should have visible = false
The text box is the filter. each time a character is typed to the exit box,
the listbox is filtered and results placed into the 2nd listbox. Works well
and can easily be adapted for adding values if they don't exist.

If this is atill an issue, I can let you have a demo spreadsheet.



"REM" wrote:

I am struggling to write code that allows the user to progressively
select a value from a list. For example from a long list the user
could type R to show all the items starting with R, then type o, to
reduce the list to all items starting with Ro etc.

Secondly if the user types a term that is not on the list, it should
be added to the list for future selection.

As I see it this is the primary purpose of a combo-box but I cant find
the above code. Any help will be appreciated.
Thanks,
Rod