combo box error

[ashgull80]

hi

i have a combo box in a form that populates a list from a worksheet of regular companys.
but if its a company i dont use often i want to just type there name into the cbo, but this causes a runtime error.
is it possible to do this?

thanks ash

[GTO]

...i have a combo box in a form that populates a list from a worksheet...
Greetings Ash,

When you say "populates a list", do you mean: populates the combo box?

Assuming that part for the moment, exactly how is the combo box being populated?

Mark

[Kenneth Hobs]

Without seeing code, I am guessing that you have the combobox property MatcEntry set to True. Set it to false if you want to just type an entry that does not exist.

[ashgull80]

hi thank you for your help.
i did not have it set to false so this was where my problem was but i have now changed my approach for a few reasons.
could you possibly help me with another issue though.
i have a userform that i input new companys details into a worksheet with, but when i enter the data through the form i would like the sheet to be sorted so the companys are in order.
thanks again
ash

[Kenneth Hobs]

Please ask new questions in new threads. Include a simple workbook if needed.

Basically, it sounds like recording the macro to sort will get you 99% there. The macro would just need to sort based on a dynamic range rather than the macro recorded static range.