>In a List Box, how to known the item before the interactiveChange Event triggered?
You mean the item in the list before the one that you change?
if so you can use .ListBox.ListItem( .ListBox.ListIndex-1)
If the current list item, the one being changed the just:
.ListBox.ListItem( .ListBox.ListIndex)
HTH
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.