• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

create form with excel


New Member

A list of students' names is already typed in Table1 in the DATA sheet.

I designed a form so that after entering the items and pressing the Save button, that information is saved in a table in the DATA sheet, But there are problems that I cannot solve:

  • If a new student is entered in "new student", the entered name will be compared with the existing names in first column of Table1 and added to the end of the list if it is not duplicated. If duplicated, give an error message.
  • The first column of Table1 should be automatically considered as the cmbNameSTU combo box list.
  • If the student's name is typed in "Name" (and not selected from the list), when the Save button is pressed, the typed name will be compared with the existing ones, and if it is not in the list, it will give an error message.
  • While typing in "Name", the combo box will open and the items that start with the typed character will appear automatically.
File attached.



Excel Ninja
You seems to skipped basic duties per Forum Rules ... actually three times
Please, reread Forum Rules, those are for You too:
  • Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
  • If you do cross-post, please put that in your post.
  • Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.