Combo Edit box
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? |
Combo Edit box
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? |
Combo Edit box
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? |
Combo Edit box
On Apr 4, 7:58 pm, SoNew2This
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 he http://www.contextures.com/xlUserForm01.html HTH Chris |
All times are GMT +1. The time now is 11:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com