View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 2-column combo box via code...

doesn't have anything to do with array index per se. Column numbering and
row numbering in the list starts with zero. Option Base 1 wouldn't change
that, so that is why I said it isn't array indexing per se.

--
Regards,
Tom Ogilvy



"DoctorG" wrote in message
...
Tom,

I saw, judging by your code, that my main mistake for not getting the 2nd
column was that I was adding values (0,1) and (0,2) in the

ComboBox.AddItem,
whereas I should be using (0,0) and (0,1).

Array indexing starts with 0, unless otherwise suggested (Base=1). Right?

Thanks [again] for everything!!