is there a command in vba that i can use in a user form to scroll up or down?

[rholdren]

Just a quick question about scrolling in a user form. I am just looking for a command that I can use in a userform that allows a user to click on a button and scroll to the top of the page. I've been reading all over the place that sendkeys are a nasty little thing and everybody has a thousand options with massive amounts of coding and placing that code in a separate sub but I was just curious if there was a command in vba like there is in a macro

for example in a macro for the sheet I could have ActiveWindow.SmallScroll Down:=84

but that won't work on a userform. Is there something that replaces ActiveWindow when using a userform? I'm just curious. In my attempt to develop my skills I keep looking at things that seem to be common issues with excel and vba. Usually here you can find a simple easy to diagnose solution to the problem. But in researching the sendkey issue nobody bothered to ask the question I did above.

Any thoughts? no need to post any code I was just curious. Thanks

 

[JLGWhiz]

I was just curious if there was a command in vba like there is in a macro

Macros use VBA and VBS as the coding language in Excel. The SmallScroll, ScrollRow and ScrollColumn methods are all avaiable in both.