ic..I just want to get every textbox value and perform some calculation then
put the result in some cells. How to get the value of those textbox in the
controls collection?

"merjet"
groups.com...
Thanks...but how to group them into an array?

They are in the Controls collection already. If you want them in an
array, you will have to build it youself.

How to code in the 'do something else ?

I don't know what you are trying to do or why you want them in an
array.

Merjet