Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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.



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to reference cell created from dropdown list in a combo box? Vishwas Excel Discussion (Misc queries) 1 December 2nd 08 02:41 PM
Disable dropdown list (Combo box -"Form control") Vinod[_2_] Excel Worksheet Functions 1 November 5th 07 06:01 PM
result of selecting from the dropdown list should be a dropdown list No News Excel Worksheet Functions 0 July 5th 06 04:09 PM
combo box dropdown list pczmut Excel Worksheet Functions 0 June 29th 06 03:12 PM
After Workbook closes all my combo boxes do not retain dropdown list. cwsax Excel Programming 0 November 6th 03 10:25 PM


All times are GMT +1. The time now is 12:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"