ijswalker
02-16-2006, 02:08 PM
Does anyone know how to limit the number of items in my list to show in my combo box. Right now I have specified the range for my list
e.g A1:A30
When I select from the list, the combo box displays all items from A1:A30 including those rows that are blank. Over time the user will enter more items into the combobox and when it is saved it will populate the range.
However, this range might go beyond 30 items and I would like the combo box to only display the items in the list. If there are 5 items then display 5 items. If there are 100 items then display 100 items.
What I'm really getting at is that I don't want to have to mess about with increasing ranges everytime I add or delete a new item to the list. Can this be done automatically?
Thanks
Ian
e.g A1:A30
When I select from the list, the combo box displays all items from A1:A30 including those rows that are blank. Over time the user will enter more items into the combobox and when it is saved it will populate the range.
However, this range might go beyond 30 items and I would like the combo box to only display the items in the list. If there are 5 items then display 5 items. If there are 100 items then display 100 items.
What I'm really getting at is that I don't want to have to mess about with increasing ranges everytime I add or delete a new item to the list. Can this be done automatically?
Thanks
Ian