Within a Form I have a selection on a pull down menu - However if somon
wants to add another item to the list I do not know how to write th
code for it.

Example :


With cboWho
.AddItem "Client"
.AddItem "Vendor"
.AddItem "Friend"
.AddItem "Family"
End With

Someone wants to come along and add Cient - Bank and Client - Sales. I
there some way that if they type this in the combo box field that i
can update the script on the Form so that that option will be availabl
next time:

With cboWho
.AddItem "Client"
.AddItem "Client - Bank"
.AddItem "Client - Sales"
.AddItem "Vendor"
.AddItem "Friend"
.AddItem "Family"
End Wit

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

Not unless you store the information some non volatile place (like a
worksheet) and then use your code check if there are additional entries and
then load it/them into the combobox.

--
Regards,
Tom Ogilvy

"neeas" wrote in message
...

Within a Form I have a selection on a pull down menu - However if somone
wants to add another item to the list I do not know how to write the
code for it.

Example :


With cboWho
AddItem "Client"
AddItem "Vendor"
AddItem "Friend"
AddItem "Family"
End With

Someone wants to come along and add Cient - Bank and Client - Sales. Is
there some way that if they type this in the combo box field that it
can update the script on the Form so that that option will be available
next time:

With cboWho
AddItem "Client"
AddItem "Client - Bank"
AddItem "Client - Sales"
AddItem "Vendor"
AddItem "Friend"
AddItem "Family"
End With


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/