Textbox value to add item in Combobox

Is there any way to add item in combobox based on textbox value?

For example:

I have a textbox, Combobox and Commandbutton. When i enter a data in textbox and click the Commandbutton, that data will add in Combobox.

Maybe something like this...

Please Login or Register  to view this content.

Hi AlpaFrog, it works! how do i permanently saved the new item in combobox? when i add new item and close the workbok, combobox was back to zero item.

Could you please provide me the code for that?

i have this code, how do i link the combobox items in range?

Please Login or Register  to view this content.

Can anyone help me on this?

Please Login or Register  to view this content.

Hi Alphafrog, perfect! thanks a million! by the way could you please help me with my other thread regarding textbox events? Here's the link of my other thead: http://www.excelforum.com/excel-prog...html?p=3193799