Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I am attempting to use the ScrollRow and ScrollColumn properties of the ActiveWindow. My problem is when a user clicks on an item in a list box I want the activewindow to scroll to the relevant range for that item so that the user doesn't have to do it herself, ie ActiveWindow.ScrollRow = SourceRange.Row ActiveWindow.ScrollColumn = SourceRange.Column Unfortunatly both the scrollrow and scrollcolumn props don't work and neither does the ActiveWindow.ScrollIntoView. I have also tried the Range.Show method. I have set the modal property of the form to false, and so I can move around the window manually. All that happens when ScrollRow etc is used seems to be that the selection the was present when the form first started comes into view. I have tried to set selection programmatically first but this doesn't work either. Thanks for any help. --- Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ActiveWindow.SelectedSheets.PrintOut | Excel Programming | |||
Help with ScrollRow | Excel Programming | |||
ScrollRow | Excel Programming | |||
ActiveWindow.ScrollColumn Sort | Excel Programming | |||
Using ActiveWindow.PointsToScreenPixelsY | Excel Programming |