T
TesterEd
Hi All,
Fairly new to the forums so apologies if i'm not entirely clear firs
time in what i'd like some support with.
I'd like to have a listbox (in a userform) where the user is able t
pick "add new" from a listbox (where the option they want may not b
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 i
essentially for a dynamic list, but i'd like it to work both ways. So i
I add something new to the list in the worksheet its updated in th
listbox, but if I choose to add (as my users would) a new item, I can d
this through the listbox and it adds it to the range in the worksheet.
Many Thanks,
E
Fairly new to the forums so apologies if i'm not entirely clear firs
time in what i'd like some support with.
I'd like to have a listbox (in a userform) where the user is able t
pick "add new" from a listbox (where the option they want may not b
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 i
essentially for a dynamic list, but i'd like it to work both ways. So i
I add something new to the list in the worksheet its updated in th
listbox, but if I choose to add (as my users would) a new item, I can d
this through the listbox and it adds it to the range in the worksheet.
Many Thanks,
E