Solving "Type miss match problem in For ..... Next

[Ali Balleya]

Being a new user of Excel programing I faced the following problem:
I have a text Box named txtPayeeName repeated in a Form 4 times, (txtPayeeName , txtPayeeName1, txtPayeeName2, txtPayeeName3).
I want to hide the three TextBoxes and leave the first on visible.
I tried to use For ...Next, but I always get "Type Miss Match" error.
this is what I tried:

Please Login or Register  to view this content.

I expected it to Read as follows:
txtPayeeName1.Text.Visible = False
txtPayeeName2.Text.Visible = False
txtPayeeName3.Text.Visible = False

So, can anyone show the mistake I made and the correction.

[6StringJazzer]

Your code looks like a shot in the dark. There are multiple problems with your code. Not sure how you came up with that. Rather than listing problems, here is untested code I think will work. If not please attach your file.

Please Login or Register  to view this content.

[davesexcel]

At first glance, there is not "txtPayeeName4"

[KOKOSEK]

You don't have textbox4 so you can't looping to 4.

Please Login or Register  to view this content.