You can emulate a control array with an event class, but unfortunately not
all of the events are exposed to this class. Which events are you after?


---
HTH

Bob Phillips

"vb6user" wrote in message
...
I'm using VBA with Excel 5 and developing a form. Under VB6 I'd create a
control array to allow me to access 10 text boxes using a loop. VBA
doesn't
appear to allow this. Is there any way to simulate a control array eg by
programatically modifying the names of the text boxes?

Thanks