Problem in combobox and textbox

[abduljaleel.mca]

Hi,

I need to enter a project name in the textbox (Name: txtProjectName) and the entered project name will be automatically stored in the combo box (Named: ProjectNames). No problem in the above steps. The problem is here, it need to show the error if I enter the project name which is previously exist. The below code doesn't work for me

Please Login or Register  to view this content.

It shows error for each project I enter in the textbox even though the project name doesn't exist already.

Please help.

[abduljaleel.mca]

Hi,

No response yet for the above thread, Please let me know if anybody can help me out on this.

[jwright650]

In your For/Next loop, you have two different variables called out...."i" in the For statement, and "I" in the Next statement

[abduljaleel.mca]

Thanks for the reply John, but it was not the error.
I did it in different way and got the answer. Just stored all the values from combo box to another sheet and used the below formula.

Please Login or Register  to view this content.