Can someone point me in the right direction? I would like to create a combo
box or even a list box but also have the ability for the user to be able to
add and deleted items in the list. Is this possible in VBA?

You can create a dynamic named range and insert that into the combox box. Go
to youtube and type in Dynamic Combobox... I was bored at work one day and
put that on there for a friend.

"SoNew2This" wrote:

> Can someone point me in the right direction? I would like to create a combo
> box or even a list box but also have the ability for the user to be able to
> add and deleted items in the list. Is this possible in VBA?

Thanks, that was a very nice link. I was hoping to "go the other way" and
enter or delete the data in the list box and have it write to the area in
the worksheet, instead of workbook to list?

What I am trying to do is present a list of say predefined song titles and
then have the user be able to either add to the list or remove from the list
those names without accessing the underlying area of the worksheet. Am I off
base here?

Thanks again.

"akphidelt" wrote:

> You can create a dynamic named range and insert that into the combox box. Go
> to youtube and type in Dynamic Combobox... I was bored at work one day and
> put that on there for a friend.
>
> "SoNew2This" wrote:
>
> > Can someone point me in the right direction? I would like to create a combo
> > box or even a list box but also have the ability for the user to be able to
> > add and deleted items in the list. Is this possible in VBA?

On Apr 4, 7:58 pm, SoNew2This <SoNew2T...@discussions.microsoft.com>
wrote:
> Thanks, that was a very nice link. I was hoping to "go the other way" and
> enter or delete the data in the list box and have it write to the area in
> the worksheet, instead of workbook to list?
>
> What I am trying to do is present a list of say predefined song titles and
> then have the user be able to either add to the list or remove from the list
> those names without accessing the underlying area of the worksheet. Am I off
> base here?
>
> Thanks again.
>
> "akphidelt" wrote:
> > You can create a dynamic named range and insert that into the combox box. Go
> > to youtube and type in Dynamic Combobox... I was bored at work one day and
> > put that on there for a friend.
>
> > "SoNew2This" wrote:
>
> > > Can someone point me in the right direction? I would like to create a combo
> > > box or even a list box but also have the ability for the user to be able to
> > > add and deleted items in the list. Is this possible in VBA?

Yes, it's possible. It's kind of messy to run forms like what you
describe without saving the data somewhere, but it can work ...

If you have any specific questions, post 'em here after you do a
little reading here: http://www.contextures.com/xlUserForm01.html

HTH

Chris