How do I add text that a user enters in a combobox to its already existing list?
My combo box drop-down list is populated with data contained in an Excel worksheet range of (IS1:IS255).
ROW SOURCE PROPERTY is set to this range.
How do I then add user entered text into my combo box list so that my range will increase to IS1:IS256, so the new entry will be added to my combo box. How is this done?
My combo box drop-down list is populated with data contained in an Excel worksheet range of (IS1:IS255).
ROW SOURCE PROPERTY is set to this range.
How do I then add user entered text into my combo box list so that my range will increase to IS1:IS256, so the new entry will be added to my combo box. How is this done?