Since you didn't provide a link for me to find the template I'll have to
guess at a solution:
Try right clicking on the list box and see if you get a "Format
Control" option.
If so, click on it and then choose the "Control" tab in the resulting
window.
You should see on the top line the range currently being referenced.
Left click within that line to edit it and type in your new range
Failing that method you could try going to your data list containing
your 12 items and select 5 cells starting with the 2nd one. Now click
on the Insert command in the main menu and choose "Cells". Then select
"Shift cells down"
BUT MAKE SURE IT DOESN'T AFFECT DATA BELOW THE LIST BEFORE DOING THIS
Now use those inserted cells to expand your list and delete the data in
the 5 extra cells you'll now have at the bottom.
The control should automatically adjust its range to the 12 cells
--
Cutter
------------------------------------------------------------------------
Cutter's Profile:
http://www.excelforum.com/member.php...fo&userid=9848
View this thread:
http://www.excelforum.com/showthread...hreadid=531177