View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
clara clara is offline
external usenet poster
 
Posts: 252
Default is there an Eval() in Excel VBA

Hi all,

I am going to handle a group of controls which are in
"txtControl1","txtControl2",
"txtControl3",... format. So, It is likely to use a loop in which the
"txtControl" part is concacted with the number part like "txtControl"&i, so I
like to use a Eval function to converse the string "txtControl"& i into
control. How can I do it?


CLara
--
thank you so much for your help