Prev: printer paper will not advance
Next: Double click to send cell to another app?
From: dhstein on 27 Mar 2010 13:46
I have a menu set up for a user to get information based on a choice from a
drop down list. The event macro will go to a specific location based on the
choice. The location is in the same worksheet but I have a split window - so
the information to display is on the right while the menu is still on the
left. Right now I use a "GoTo" to go to the appropriate section, but it
doesn't always frame correctly in the display window. For example if the
goto goes to cell Z1, the window might show columns W to Z, but I really
want columns Z to AC. So how do I force the "goto" to set up the window from
Z to AC. I hope I made this clear. Any help is appreciated.
From: Rolf on 27 Mar 2010 14:56
goto AC then goto Z

"dhstein" wrote:

> I have a menu set up for a user to get information based on a choice from a
> drop down list. The event macro will go to a specific location based on the
> choice. The location is in the same worksheet but I have a split window - so
> the information to display is on the right while the menu is still on the
> left. Right now I use a "GoTo" to go to the appropriate section, but it
> doesn't always frame correctly in the display window. For example if the
> goto goes to cell Z1, the window might show columns W to Z, but I really
> want columns Z to AC. So how do I force the "goto" to set up the window from
> Z to AC. I hope I made this clear. Any help is appreciated.
From: tompl on 27 Mar 2010 15:18
You can set the cell that you want in the upper left corner of the
ActiveWindow or the ActivePane with the following language:

ActiveWindow.ScrollRow = 10 'Row 10
ActiveWindow.ScrollColumn = 5 'Column E

Or:

ActiveWindow.Pane(2).ScrollRow = 10
ActiveWindow.Pane(2).ScrollColumn = 5

You would need to test the “Pane” part because I am not too sure how it
would workin your specific worksheet.

tom

From: tompl on 27 Mar 2010 16:02
Sorry, that needs to be:

ActiveWindow.Panes(2).ScrollRow = 10
ActiveWindow.Panes(2).ScrollColumn = 5

Not:
ActiveWindow.Pane(2).ScrollRow = 10
ActiveWindow.Pane(2).ScrollColumn = 5

Tom


"tompl" wrote:

> You can set the cell that you want in the upper left corner of the
> ActiveWindow or the ActivePane with the following language:
>
> ActiveWindow.ScrollRow = 10 'Row 10
> ActiveWindow.ScrollColumn = 5 'Column E
>
> Or:
>
> ActiveWindow.Pane(2).ScrollRow = 10
> ActiveWindow.Pane(2).ScrollColumn = 5
>
> You would need to test the “Pane” part because I am not too sure how it
> would workin your specific worksheet.
>
> tom
>
 | 
Pages: 1
Prev: printer paper will not advance
Next: Double click to send cell to another app?