Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello.
I am attempting to remove an item from a collection and for some reason I'm having trouble with the syntax. I can add items just fine: Select Case Item Case Is = "CD" ActiveSheet.OLEObjects("Groups").Object.AddItem "CD Players" Case Is = "DVD" ActiveSheet.OLEObjects("Groups").Object.AddItem "DVD Players" End Select What do I need to remove a single item that I need to specifically identify? (i.e. removing the "DVD" from the collection.) Any help would be greatly appreciated. Thanks. Dan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to ask for a item# and then show all details for that item | Excel Discussion (Misc queries) | |||
To find rate of each item from item.xls and to copy price.xls | Excel Discussion (Misc queries) | |||
Item numbers result in item description in next field in Excel | Excel Worksheet Functions | |||
Removing a subtotal from an insert item in a pivot table | Excel Discussion (Misc queries) | |||
Removing the RECENTLY OPENED submenu item | Excel Programming |