Looping through TextBoxes

**davidryder** · 06-16-2007, 09:41 AM

Hello, I have a worksheet and 42 text boxes that I would to be able to clear.

\1

This is what I have thus far:

Please Login or Register  to view this content.

I can't figure out how to substitute i into 1, like TextBoxi.Value

**boylejob** · 06-16-2007, 10:34 AM

Hello David,

Try this and see if it works for you

Please Login or Register  to view this content.

Hope this helps!

**royUK** · 06-16-2007, 11:42 AM

What is the source of the TextBoxes?

**Leith Ross** · 06-16-2007, 03:02 PM

Hello Davidryder,

This code will clear all the TextBoxes on the active sheet, provided they are Control Toolbox TextBoxes and not HTML.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

**davidryder** · 06-16-2007, 11:31 PM

Originally Posted by Leith Ross

Hello Davidryder,

This code will clear all the TextBoxes on the active sheet, provided they are Control Toolbox TextBoxes and not HTML.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Thank you so much, that worked perfectly!! What are the chances of you somewhat explaining what OLEObjects is?

At any rate, thanks!