ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Adding/Saving Combo Additems (https://www.excelbanter.com/excel-worksheet-functions/134785-adding-saving-combo-additems.html)

10_a_c

Adding/Saving Combo Additems
 
Hello:


I do not know if this is the corrrect group for this question but here it
goes. I can add items to a Combo Box either via the Box properties or in the
VB code. However, sometimes I compare the contents of the combo list to a new
item,Excel cell, and I want to add that new found item into the Combo list. I
can do that in the code for that particular instance but the next week or
when I run the application/VB code again, the list is back to where it was;
without the new item. I need code to save the new values into the Combo box.

Let me thank you in advance for your time and any and all suggestions.


10_ac


All times are GMT +1. The time now is 01:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com