I never used 2007 but in 2003 i would create a dynamic range instead
of a fixed range.

Maybe this will help you:
http://www.ozgrid.com/forum/showthread.php?t=68869

hth

Carlo

On Dec 25, 5:29*pm, Arthur Pappas
wrote:
*I'm using Excel 2007*

1. Sheet2 cells A2 A6 of my workbook constains a list (expense
categories). I selected these cells & typed EXPENSES in the name box.

2. Sheet1 is selected. I go to the 'Developer' tab, 'Insert', then I select
'Combo Box' (form controls). I place my Combo Box in C1. I right click the
Combo Box, select 'Format Control', then in the Iinput Range I type EXPENSES.

3. All works fine until I add another line to the EXPENSES list on Sheet2!!!

All I ask is one simple question:

How can I make the EXPENSES column grow/shrink to my needs & have that info
reflected in my Combo Box?

I am at my wits end & can't remember cursing so much since high school!!!