Nope. Not just '97. It's across the board and is "by design". In VB you may
be able to use a change event  within a control array.. Dunno.. But VBA
doesn't support arrays of controls.

In VBA the closest you can come to a control array is to use controls with
similar names and loop through the complete control set picking up what you
need.

This would involve some tricky coding... First you would have to save the
state of all the controls and then loop through them all when *any* of them
changed.

Not worth it.

The best, and only... solution I've found in VBA so far is to make one Sub
that does what you want and stick it in the change/before update/after
update ... As appropriate ... event of *each* copntrol you're looking at.