[Excel, VBA] Add the value taken from the user to my range for ActiveX ComboBox

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

[Excel, VBA] Add the value taken from the user to my range for ActiveX ComboBox