View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ian B Ian B is offline
external usenet poster
 
Posts: 8
Default Using a DO loop to add values into a textbox

I have a series of textboxes in a form and want to enter the values from an
array into each of the textboxes.

Is there any way to do this using a DO loop rather than having to write out
each textbox one by one

something like

co1 = 0
Do
co1 = co1 + 1
userform1.textbox(co1) = varray(co1)
if co1 = 100 then exit do
Loop

rather than

userform1.textbox1 = varray(1)
userform2.textbox2 = varray(2)
etc
etc

Ian B