Posted to microsoft.public.excel.programming

vb6user

external usenet poster

Posts: 1

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Control arrays on Excel 2007 userforms	Informative	Excel Discussion (Misc queries)	1	February 26th 08 09:36 PM
Arrays - declaration, adding values to arrays and calculation	Maxi[_2_]	Excel Programming	1	August 17th 06 04:13 PM
Control Arrays	Charles Watson	Excel Programming	2	November 14th 04 01:52 PM
Control Arrays?	SixSigmaGuy	Excel Programming	5	November 11th 04 10:47 AM
On the lack of control arrays.	Jan Nordgreen	Excel Programming	3	October 11th 03 12:11 AM

All times are GMT +1. The time now is 07:50 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us