Add a company to a combo box

[JUALOP60]

Hi,

I am about to finish an application in excel 2007,
I have a combo box which list companies and when i select the
address/city/code get populated nicely.

I created a name range to use in the combo box (Activex Control) but it will not work i have to say the range for example PAYABLES!A2:G60 AND LINK CELL E50, that's work fine
but the problem is that if i update the database with a new company it will not be in the combo box unless i manually extend the range to let's g61.

is there a way to automatically update the combo as well with the new company?

if type in combo box property in ListFillRange: =PAYABLES the name i created will not work.

thank you

 

[SkipVought]

Use a NAMED RANGE for you company list

faq68-1331

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}