larn
02-17-2001, 12:39 PM
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!!!!
|
View Full Version : how can i add Value list in combo box ? Please Help!!! larn 02-17-2001, 12:39 PM 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 02-17-2001, 02:03 PM 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 |