Any way to use a Combobox quickly for users?

[Oliver Dewar]

I am finding that comboboxes on userforms don't handle speed entry very well.

My problem is that if you click on the combobox then quickly scroll down, often the dropdown list disappears and whatever the curser was on is selected.

It seems (strangely) to happen if you move to the list before the shadow appears under the list.

Is there a way to modify a comboboxes behaviour so that it doesn't need the shadow, or loads more swiftly?

(Has anyone else noticed this or is it just me?)

 

[Norie]

How are you currently 'loading' the combobox?

It should be populated before the user starts using it.

If you want the user to make an entry/selection quickly then they can just type it in.

If it's a match to an item of the list it should auto complete.

 

[Oliver Dewar]

Thanks Norie,

I'm just populating it by selecting the source code in the properties window.

I'll look at allowing them to type as well.

I just find when I'm wizzing through the forms (as I would as a user) I'm often too fast for the combobox and the error I described above happens frequently.

Have you experienced what I'm describing?

 

[Norie]

Oliver

You've kind of lost me - where is this combobox located?

I thought it was on a userform.

By the way, you don't actually need to do anything to allow the user to type in the combobox - if it's on a userform.

It's also easy to check if what they've typed is valid, ie it's an item on the list.

 

[Oliver Dewar]

Hi Norie,

Yep it's on a userform.

I should have said I'm using Rowsource (not source code... it's late in Aus!)

But I'm still getting this bug when I select too quickly and then I am constantly selecting twice per combobox.