ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   XL97:Combo/DropDown box and Not In List (https://www.excelbanter.com/excel-programming/289986-xl97-combo-dropdown-box-not-list.html)

nick42

XL97:Combo/DropDown box and Not In List
 
What would be the best methods to mimic the "Not In List" and be able to add
the item to the combo box on a Userform?
I'll be storing the values in the registry - that part I have figured out.




Tom Ogilvy

XL97:Combo/DropDown box and Not In List
 
Check the list, and if the item is not found, then use AddItem to add it to
the list. Then use existing code to put the list in the registry.

--
Regards,
Tom Ogilvy

"nick42" wrote in message
...
What would be the best methods to mimic the "Not In List" and be able to

add
the item to the combo box on a Userform?
I'll be storing the values in the registry - that part I have figured out.







All times are GMT +1. The time now is 05:25 PM.

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