Autocomplete based on a range in another column

[shivers]

I need to input column B text values regularly, and for convenience as I type fast and hate using the mouse to interrupt the input flow I'd like to have column B autocompleting based on a list from J3:J31. The text values in this J list are a bit long and many somewhat similar to one another, so if I am typing in B5 "Deposit for Hec" and there are only "Deposit for Henry Name" and "Deposit for Hector Name" in the J list, it should autocomplete for Hector, and so forth.

Thank you for any help!

[mehmetcik]

You need a macro with a key press event.

That is not available in a worksheet or a workbook.

What if selecting a cell in column B opened a userform for you to type into?

Ok this should get you started.

I used a sheet specific macro to open the userform when you select a cell in column B
Right Click on the sheet name at the bottom of excel and select view code.
Paste this code in the module and close it.

Please Login or Register  to view this content.

I then created a userform with one textbox and one Listbox.

Please Login or Register  to view this content.

The above does what you described.

However if we add the following code

You can select text simply by clicking on a line in the Listbox.

Please Login or Register  to view this content.

Ok I have tidied up the code in this sample workbook.