Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel combo box edit | Excel Discussion (Misc queries) | |||
edit combo boxes | Excel Programming | |||
Combo drop-down edit box | Excel Programming | |||
Can you edit a combo box? | Excel Discussion (Misc queries) | |||
Edit Links - Combo Box Problem | Excel Worksheet Functions |