How to create a loop of TextBox Names

I use the following code to clear TextBoxes on a sheet when it is first activated:-

Please Login or Register  to view this content.

My problem is that there are another 8 TextBoxes that I need to ensure are cleared
I do not want to change the names of the TextBoxes. How can I create a loop through 9 names?
John

WBD
Many thanks for your suggestion which links nicely to that from sintek. I can't use it as it stands for there are other textboxes which have to remain with valuesw.
Bu I have not coded with OLEObjects before and it looks like an area I should get to know.
John

Sintek, Many thanks for your help which works just fine for me. Thanks also for pointing me to OLEObjects. They look easier to use than remembering a list of 6 or 7 objects needed to refer to a shape.
John