How to Scroll Window Views from Object to Object (147190)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
This article was previously published under Q147190 SUMMARY
By using Microsoft Visual Basic for Applications code, you can scroll from
object to object on a sheet without changing the current cell selection.
The ActiveWindow methods, ScrollColumn and ScrollRow, control the position
of the current Window view of a Worksheet. By determining the position of
an object on the sheet, the view can be scrolled to display that object.
The position of the object can be found using the TopLeftCell property of
the DrawingObjects properties. Therefore, any object can be viewed just by
proper referencing within the code.
REFERENCES
For additional information about getting help with Visual Basic for
Applications, please see the following article in the Microsoft Knowledge
Base:
163435 VBA: Programming Resources for Visual Basic for Applications
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbdtacode kbhowto kbProgramming KB147190 |
---|
|