Hello there,

I have a workbook with appointments that I make daily. It contains addresses and dates mainly. It contains few sheets and the more important are:

Sheet 1: "Master Search" and of course sheet 2 (contains data and diary)


In sheet one in Cell E2 I have got a combo box where user can type an address. The code that I have is shown below:

Please Login or Register  to view this content.

What I would like is when user start typing and address eg. 12 Elt, to show some more possibilities such as, 12 Eltham, 12 Elton, 12 Eltous etc. and show them at the drop down whithout having to press it. Preferably I would like 12 max showed at the same time without scrolling. Can anyone please help?



Many Thanks