Add the value taken from the user to my range for ActiveX ComboBox

[niksirat]

Hi everyone,

I defined

• a ActiveX ComboBox named "cmbPeymankar",
• a Text Box (ActiveX control) called "txtNewPeymankar".
• a Command Button (ActiveX control) called "Add".

I have a table named "Table1" in sheet "DATA" so that the first column of Table1 contains the names that should be displayed in the cmbPeymankar list and 10 items are already written in it.

I have three questions:

1. How to define the value of "ListFillRange" of cmbPeymankar so that the values of column 1 of Table1 are displayed in its list?
2. What command should I write for Add button to add the value taken from the user for txtNewPeymankar to the end of the column 1 of Table1?
3. The value of cmbPeymankar can be selected from its list. If the user wants to type its value, how can I write an error message if the entered value is not equal to any of the predefined items for cmbPeymankar (in column 1 of Table1)?

 

[p45cal]

cross posted

 

[vletm]

niksirat
As you have read about the rules of both forums which are also for you, which you should follow as well.
Please reread:

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

• 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.