list or combo box?

D

Doug

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.
 
P

Patrick Molloy

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.
 
D

Doug

Sorry, I wasn't clear. I want this on a user form. I have the sheet locked
so the user can't mess with it. I have a range with the RowSource as
"Names". Do I undo the RowSource Proberty to use the code. Can you give me
a sample of code I could use.
Thanks
Doug
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crating User Form to Add Names 1
MS Word List Bug 0
Creating a Search using a combo box and then creating a report. 4
Combo or list box 0
Clearing combo boxes and a text box 2
Grouping Names in Mail Merge 0
Combo box 0
list or combo box 0

Top