Thread: Calling objects
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stewart[_3_] Stewart[_3_] is offline
external usenet poster
 
Posts: 8
Default Calling objects

I have some textboxes named TB1 thorugh to TB10. I want to
call these text boxes using a for-next loop. How can I
make this work? This is kind of what I want to happen, but
it obviously doesn't work...

for a =1 to 10
TB a .value="Whatever"
next a

Thank you for any help you can give me on this matter!!!

Stewart
MOS Excel Expert (not that it's doing me much good!!!)