View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
brichard429 brichard429 is offline
external usenet poster
 
Posts: 9
Default Deriving a name from variables

I have 22 CheckBox objects named CheckBox1, CheckBox2 etc. I would like to
substitue a variable to represent the name in the expression
"Sheet2.TextBox1= False" by using a do loop and varying the number portion
of the word TextBox. Any suggestions?
--
Bernie