how can i add Value list in combo box ? Please Help!!! (1 Viewer)

[larn]

I have tried to add new value in existing combo box's value list? i don't know how to save it for next use. Using On Not in List properties ? but what should the macro or VBA be? I am very new user, please help me!!!!

 

[Jack Cowley]

I would suggest putting your values in a table rather than a value list. Then use the NotInList event to add new values to the table. This article will tell you how to use the NotInList event....
http://support.microsoft.com/support/kb/articles/Q161/0/07.asp?LN=EN-US&SD=gn&FR=0&qry=q161007&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC97