>>I have a combobox with RowSourceType=0 and 4 columns. I populate the combo using AddListItem(). What I want to be able to do is, when an item is selected, column1 value shows in combo and columns 2-4 show in 3 following textboxes respectively. Any ideas? TIA
>
>You can use the combo list property:
>
>text1.value = combo.list(1,3), for example, in combo click...
More generically, I should add,
text1.value = this.list(this.listitemid,ncol) in combo click
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.