LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default ActiveWindow.ScrollRow and ScrollColumn

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ActiveWindow.SelectedSheets.PrintOut excel-lent Excel Programming 4 June 15th 05 03:48 PM
Help with ScrollRow Glen Mettler[_4_] Excel Programming 0 November 18th 04 01:24 PM
ScrollRow Glen Mettler[_4_] Excel Programming 0 November 17th 04 03:04 PM
ActiveWindow.ScrollColumn Sort hotherps[_102_] Excel Programming 1 August 13th 04 02:27 PM
Using ActiveWindow.PointsToScreenPixelsY Pancho Excel Programming 5 February 7th 04 11:23 PM


All times are GMT +1. The time now is 06:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"