View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
milo[_2_] milo[_2_] is offline
external usenet poster
 
Posts: 3
Default Clear Textboxes, Labels, and Checkboxes

I have a worksheet contains about 100 textboxes, labels,
and checkboxes. I would like to clear all the text from
these text boxes and labels, and uncheck all checkboxes at
once. Is there a way to set these textboxes, labels, and
checkboxes in an array and then using a loop to clear all
the text and uncheck the checkboxes instead of writing a
code for each of them (textbox1.text = "")?

Thanks,
milo