Populate Combo Box Items from Custom Defined List Box

I want Custom Defined List Box , where in the user can add,delete and modify the items in the list box and from there move the finalised list to Combo Box Drop Down at aclick of Command Button.

How could i code this requirement, anybody please

srikanthv2322Asked:
Who is Participating?
 
roger_karamConnect With a Mentor Commented:
And here is an option that will also set up a combo box (data validation) on sheet 1, A1...

-RK
listbox-combobox-v2.xlsm
0
 
rspahitzCommented:
Depending on how strict you want this to be, you can, for example, assign a column for the user to enter values and let them put whatever they want and have that list applied to a combobox through a named range.

You could also make a VB UserForm that manages all of this more effectively but you'll have to give a way for users to add text, remove text, maybe change text, then when done, push to Excel.
0
 
roger_karamCommented:
Are you thinking something like this? Just a rough draft for you to play with.

-RK
listbox-combobox.xlsm
0
 
srikanthv2322Author Commented:
Awesome
0
 
roger_karamCommented:
thanks for the points!

-RK
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.