Thanks
How do it define the sequence of textboxes? By the last number of its name?
"merjet"
egroups.com...
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?

For Each c In Me.Controls
If TypeName(c) = "TextBox" Then
Debug.Print c.Value ' or c.Text
z = c.Value 'assign to variable
End If
Next c

c.Value is String, so convert or assign to a numeric variable to do
calcs.

Merjet