View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy Patrick Molloy is offline
external usenet poster
 
Posts: 1,049
Default list or combo box?

just use a spreadsheet ... the user can easily just add/edit entries. all
you need to do is sort the table

if you're planning in using a userform, then a listbox would be my
recommendation, since then the user can more easily see what data is there.

"Doug" wrote in message
...
I want to create a list of names, first and last, (30 to 40), where the
user
can add or delete names or edit existing names. I would also like the
list
to auto sort alphbetically too. Which box would work best and what code
do I
use? Thanks for the help.