View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rune[_2_] Rune[_2_] is offline
external usenet poster
 
Posts: 3
Default looping and objects

I'm a newbie and have this problem:

I have 13 textboxes called MN1, MN2, MN3 ...... MN13
when trying to set text in all of them i did this:

for i 1 to 13
Dim Temp as object
Set Temp = "MN" & i
temp.text = "test"
next i

How do i refer to an object whith i in a loop??