assistance with filling listbox.

This is driving me nuts, just can't get it too work the way I want. If the name exist once it works perfect, only when the name exist twice do I have problems. For example if you type in Airport it will fill the list box with the info I want, if you type in American Pie it does not work right because their is a American Pie 2. Can this be rewrote too fix this issure or is it impossible to do what I want. Same problem with Basic Instinct because this is a Basic Instinct 2 .

Thanks Z

Hi Z,

I think this is the way most combo/list boxes work. It will go to what you type until it doesn't match. You need to get to the space after American Pie before it knows you want to go onto 2.

What did you expect to happen?

Here is an example. Create two named ranges. Range1 and Range2. Now start doing a formula that takes a range, say Countif( ... You go to a cell and start typing a formula "=Countif(Rang...) and see that both Range1 and Range2 are still available. It doesn't know you want Range2 until you get to the first character (the 2) that is different.

I think it works as it should.

Maybe VBA can help.
This is the only code you need in Userform2

Please Login or Register  to view this content.

Listboxes clear when the form is closed

Hide<>Close

Unload = Close

When you close the Userform then the controls clear.

When it opens again the form is reloading with the data as it should according to the initialize code provided by snb

If you want the controls to not display a value then amend the code like this

Please Login or Register  to view this content.

Hi Roy

When I try and use that code I get Run-Time Error Object Required.


I made a change here .ListIndex = combox1.ListIndex
.ListIndex = combobox1.ListIndex

Still does not clear form on startup.

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

Roy had a typo:

Please Login or Register  to view this content.

should be

Please Login or Register  to view this content.

you must be able to debug typos yourself.

Look in VBEditor's for nomenclature.
Clear in a Listbox or combobox has a special meaning, do not use it if you mean: the listbox shouldn't show anything at teh beginning

This solves your problem:

Please Login or Register  to view this content.

But for your purpose 2 comboboxes would be more approriate:

Please Login or Register  to view this content.

doesn