>>>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

Bruce, do you know about awful Combo.Listitemid problem? It happens to disappear if you open the combo, highlight new item and mouse click outside the combo.