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