how to add more (rows / cells) to a name box

**palmer19** · 06-28-2010, 02:33 PM

i have a name box which i use for a drop down menu and im trying to add new items to that drop down menu by changing the name box so i dont have to change all the individual drop down menus and i cant find any way how to add more rows/cells to a name box if anyone could help that would be great thanks

josh

**royUK** · 06-28-2010, 02:53 PM

What do you mean by name box?

**palmer19** · 06-28-2010, 02:59 PM

By name box I mean the little box near the Formosa box just to the left of that it's where you can name a range of cells or rows I.e stock so it can be used for a drop down box

**royUK** · 06-29-2010, 01:47 AM

I don't see how you can use the name Box for anything but creating or listing names in the sheet or workbook.You can add or edit names:

Insert menu->Name->Define

**foxguy** · 06-30-2010, 08:34 PM

Hi palmer19;

I believe you are talking about dynamic range names.
When you create a Dynamic Range name, the name refers to a range that can change size without having to reDefine the range name. Then your listbox will automatically add the names that you add to the list.
Check out this site http://www.ozgrid.com/Excel/DynamicRanges.htm
Here a workbook that illustrates it ListBox Example.xls
Keep in mind that Dynamic Range names will not be included in the Name Box or in GoTo (F5). You have to type them in in order to select them.