Thread: control arrays
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
vb6user vb6user is offline
external usenet poster
 
Posts: 1
Default control arrays

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