Index Numbers

[JUALOP60]

Hi,

I have a vendor database in excel,

columns:

Index Company Address City Code

so to use Combo box (Activex Control) i need to have an index number,

to update the combox when i insert a new company, i need to update the combox and increase to the next index number automatically,
I am using this =OFFSET(PAYABLES,,,,8) it shows in the combo box but will not sort neither increase index number.

is there any way with code (vba) to do that?

Thank you

 

[SkipVought]

Hi,

The simpest easiest way, is to add your Index value to a LIST and use the List as the source for the ComboBox. The key is to use a NAMED RANGE.

faq68-1331

Skip,

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