Thread: Control array
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Martin Miller Martin Miller is offline
external usenet poster
 
Posts: 1
Default Control array



"Freddie Mac" wrote:

I have several textboxes and checkboxes. I now insert them into an array but
there is something called control array? How do you use it? My help function
does not work!


This will work.

testNumber = Me.Controls("txtStart" & CStr(1))

Me.Controls("txtStart" & CStr(2)) = testNumber

So it you have textboxes named txtStart1, txtStart2, txtStart3 etc. You
obviously would use variable instead of the 1 and 2 I used.