Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
While recording A Macro with mouse, The term -- ActiveWindow.SmallScroll
ToRight:=-61 , Thats only one of them. I am using Excel 2003. I have tried to find help on the subject But to no avail . I believe that I did see it on my computer help files, But I can not find it again. support.microsoft.com/kb/213662/en-us , 191154/en-us, Both have reference to the Scroll Methods In Excel 98 & Excel 2000. Could I please find more Information on this |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
From my XL2002 help file, they are essential the same but scroll by
row/column or page: </Help SmallScroll Method Scrolls the contents of the window by rows or columns. ....... LargeScroll Method Scrolls the contents of the window by pages. expression.LargeScroll(Down, Up, ToRight, ToLeft) expression Required. An expression that returns a Window object. Down Optional Variant. The number of pages to scroll the contents down. Up Optional Variant. The number of pages to scroll the contents up. ToRight Optional Variant. The number of pages to scroll the contents to the right. ToLeft Optional Variant. The number of pages to scroll the contents to the left. Remarks If Down and Up are both specified, the contents of the window are scrolled by the difference of the arguments. For example, if Down is 3 and Up is 6, the contents are scrolled up three pages. If ToLeft and ToRight are both specified, the contents of the window are scrolled by the difference of the arguments. For example, if ToLeft is 3 and ToRight is 6, the contents are scrolled to the right three pages. Any of the arguments can be a negative number. Example This example scrolls the contents of the active window of Sheet1 down three pages. Worksheets("Sheet1").Activate ActiveWindow.LargeScroll down:=3 </Help NickHK "Quandary 11 - 3 - 07" wrote in message ... While recording A Macro with mouse, The term -- ActiveWindow.SmallScroll ToRight:=-61 , Thats only one of them. I am using Excel 2003. I have tried to find help on the subject But to no avail . I believe that I did see it on my computer help files, But I can not find it again. support.microsoft.com/kb/213662/en-us , 191154/en-us, Both have reference to the Scroll Methods In Excel 98 & Excel 2000. Could I please find more Information on this |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I wonder if you are looking in the right place in help. Are you opening help
from the visual basic editor (not the worksheet.) In the Answer Wizard Tab type in smallscroll or largescroll and you should find it. "Quandary 11 - 3 - 07" wrote: While recording A Macro with mouse, The term -- ActiveWindow.SmallScroll ToRight:=-61 , Thats only one of them. I am using Excel 2003. I have tried to find help on the subject But to no avail . I believe that I did see it on my computer help files, But I can not find it again. support.microsoft.com/kb/213662/en-us , 191154/en-us, Both have reference to the Scroll Methods In Excel 98 & Excel 2000. Could I please find more Information on this |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
problems with excel and visual basic for applications | Excel Discussion (Misc queries) | |||
Where do I find help for Visual Basic for Applications Extensibili | Excel Programming | |||
Microsoft Visual Basic for Applications Extensibilty 5.3 | Excel Programming | |||
Visual Basic for Applications | Excel Programming | |||
Visual Basic For Applications | Excel Programming |