please help with vba coding

[tango71]

Ok, so what i am trying to do is to use a vb form to view ranges on a worksheet. i dont want to change anythin but i do want to scroll through to the last row that has data. that being said, i have literally tried everything i can think of short of just writing a java script and doing what i need through there. i am an amateur at vba but do understand how coding works.
some of the things i have tried are

Worksheets("Register").Range("A1:G22000").PrintPreview

i have tried linking data to a label.
linking to a list box, a text box, you name it ive tried it. just cant get it to display anything.
I know it is probably something stupid simple that im just missing. ive been working on this for about 3 hours
i guess im just not getting it. Please help.

 

[DanteAmor]

dante, Thanks so much! i just modified the code you wrote and it worked flawlessly. Thank You Again!

I'm glad to help you. Thanks for the feedback.

 

[tango71]

@Fluff, i just tried your code again and placed it in Activate insted of initialize and it workd! Thank you both so much for the help!

 

[Fluff]

You're welcome & thanks for the feedback