Need to create a for loop that refers to a number of text boxes

Hi there,

I am trying to create a for loop that refers to a number of text boxes. I have created the code below but I am not sure how to rename textbox1.value into textbox & X.value. Any ideas?

Please Login or Register  to view this content.

Any help much appreciated.

forrestgump1980

Try this line

Please Login or Register  to view this content.

seems to be saying method or data member not found??

In this line

Please Login or Register  to view this content.

try to change 0 to 1

If it is the same problem , you have to tell us which textbox you mean .. Userform textbox or worksheet textbox?