ActiveCell.Offset via Dim

[iturnrocks]

Im creating a User Form with a long list of text boxes. I would like to make it easier for me to write the code by copying and pasting the ActiveCell.Offset statments and having the textbox number increase by 1 each time. Here is what I have done, but it does not work. If anyone knows the proper way to do this, I would appreciate it.

The Dim down works, but the nxpt does not

Please Login or Register  to view this content.

[Leith Ross]

Hello Dan,

Here is how...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[iturnrocks]

Thanks, Ill give it a try

[iturnrocks]

I tried it, it works great. Thanks Again!!!