ComboBox Backspace Strange Behaviour

Hi there,
I've got a problem with a Combobox working with autofill. It's filled with names out of
a table. If I enter the beginning of a name, it proposes me full names.
Now, if I enter by mistake one letter more, for which the ComboBox finds no entry , I want to
delete the last two letters with backspace. The first one works, but on the second one I have to press
Backspace twice.
Example:Name starts with Po, ComboBox suggests entry, I enter Poi, no entry found.
I delete the i now, it works, then the o, have to press backspace twice to delete it.
Any clues why this happens? Thanks!

Originally Posted by Norie

How are you populating the combobox?

Also, does it have any code associated with it, eg a change event?

Hi Norie,

I'm new to forums, so I'm not sure if it's considered to be 'hijacking' if I jump in here: my question is exactly the same as the one stated in the opening post.

In answer to the questions you asked: I have populated my combobox with the rowsource property. And I have code associated in the Change event and the BeforeUpdate event. I've got the combobox behaving almost exactly as I want it to with the exception of being able to backspace/delete in a conventional manner.

Do I need to provide more information?
(I'm also new to userforms and VBA. I don't know best practices - I'm just trying to make things work.)

I see this is also an old post, so I'm not sure if I can expect an answer.
I'd be grateful for any assistance.

Cheers,
Melpa