Hi All,

Fairly new to the forums so apologies if i'm not entirely clear first time in what i'd like some support with.

I'd like to have a listbox (in a userform) where the user is able to pick "add new" from a listbox (where the option they want may not be there) and they are then prompted to enter a value

So far i've only been able to create lists in VBA using things like

With ChooseFruit
Additem = "Apple"
End With

But essentially that hardcodes 'Apple' to that listbox. What i'd like is essentially for a dynamic list, but i'd like it to work both ways. So if I add something new to the list in the worksheet its updated in the listbox, but if I choose to add (as my users would) a new item, I can do this through the listbox and it adds it to the range in the worksheet.

Many Thanks,
Ed