>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...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.