New entry in a Combobox

[marcusr]

Hi,

I have created Userform where I can add or update members in our local gymnastics club.

In the Userform I am using a Combobox (showing name, sirname and birth date) to show data of members in the club in to several text boxes. The combobox is "prefilled" with all members (sorted in alphabetic order).

When I select one of the existing entries (member) in the combobox I display data linked to that member in several textboxes.

If I want to add a new member, ie a new member (name) is typed in the combobox (not already in the list), I want all textboxes to be cleared and only show the new name in the textbox used for first name. I will then fill the other text boxes manually and later add the data in to the excel register.

I do not seem to find the solution on how to clear the text boxes when a new name is entered in the combobox and I also do not know how to get the new name entered in the combobox in to the textbox "name".

Could someone help?


Thx


Marcus

[royUK]

You need to add code to check if the name exists in the list, this depends on how you are populating the combobox. Are the xisting names stored in a sheet?

[marcusr]

Hi RoyUK,

thx for input.

Yes I am populating the combobox with rows from a sheet (using 4 columns with headlines: membernumber, name, sirname, birthnumber).

Could you help me with a simple "search name function"?


Thx


Marcus

You need to add code to check if the name exists in the list, this depends on how you are populating the combobox. Are the xisting names stored in a sheet?

[royUK]

What do you want to check against, there is a chance that First names and Surnames might be duplicated. Member number would be best.

[marcusr]

Good point!

The member numbers would be unique and they are stored in cells A1:A1000

Marcus

What do you want to check against, there is a chance that First names and Surnames might be duplicated. Member number would be best.

[royUK]

can you attach a zipped xample, I need to see exactly what your combobox contains.