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

[niksirat2030]

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)?

 

[Peter_SSs]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Add the value taken from the user to my range for ActiveX ComboBox
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.
I also note that you have been told about this before both here and at least one other forum. Virtually all forums have a similar rule about cross-posting and if you read the link at the end of our rule as I've mentioned above then you will know why the rules exist. If you continue to ignore the rule in this forum you will find that you may no longer be able to post here.