How to add and delete items from a list box or drop down box?

K

kamill

The box is in a worksheet. If I could find where the list is stored I could
add to it but I can't find it.

Also I thought about making a new box but when I try to copy the information
in the column it won't let me do that either.
 
B

BizMark

kamill said:
The box is in a worksheet. If I could find where the list is stored
could
add to it but I can't find it.

Also I thought about making a new box but when I try to copy th
information
in the column it won't let me do that either.

:
-
How to add and delete items from a list box or drop down box?-
Click to expand...

Depends on whether the dropdown came from the 'Forms' toolbar or th
'Control Toolbox'.

Also on whether you're wanting to control the information shown in th
dropdowns in code or from a worksheet selection.

1. IN CODE:

If from 'Forms', you would use the code
Worksheets("Sheetname").Dropdowns("Dropdownname").RemoveItem(number o
item to delete)

If from 'Control Toolbox', you would use the code
Sheetname.Dropdownname.RemoveItem(number of item to delete-1)
- i.e. the top item is Item No. 0 (zero).


2. AS WORKSHEET SELECTIONS:

If from 'Forms',
- right-click on the dropdown box and select 'Format Control'
- check the address/range entered as the 'Input Range' and modify a
necessary to include the additional rows or remove the redundant rows

If from 'Control Toolbox',
- right-click on the dropdown box and select 'Properties'
- a VBA-style property window appears, floating on the worksheet.
- check the address/range entered as the 'ListFillRange' property an
modify as necessary.


Hope this helps.

Regards,
BizMar
 
Top