• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 663
  • Last Modified:

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

0
srikanthv2322
Asked:
srikanthv2322
  • 3
1 Solution
 
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
 
roger_karamCommented:
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
 
srikanthv2322Author Commented:
Awesome
0
 
roger_karamCommented:
thanks for the points!

-RK
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now