LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #24   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 29
Default VBA - Controlling browser scrollbars from vba

Gary,
Never had the need to scroll on a VBA frame before.
Seems like you have react to the Frame1_Scroll event with something like
wb.Top=wb.Top+RequestDy
but it all seems a strange implemetation to me.

NickHK

"gary" wrote in message
...
Nick,

I already have the browser occupying the entire frame but there is stil
stuff in the browser that does not normally need to be viewed (chart
parameters whcih I am already sending to the URL). I know the browser will
ALWAYS have to be scrolled because the charts have stuff at the top and

left
side that needs to be skipped. It would be nice for the user to be able

to
concentrate on the charts with minimal adjustment.

Gary

"NickHK" wrote:

Gary,
Why not just size the browser control to fit the frame and scroll the
browser if needed.

NickHK

"gary" wrote in message
...
Nick,

Sorry about the duplicate message but my connection timed out.

Anyway, I
see the scrollbars are part of the frame that contains the browser. I

can
manually move the scroll bars and the chart in the browser responds.

What
I
need is to be able to send a command from vba to do this. The

following
code
appears to do nothing (but it compiles).

FrameWeb.Enabled = True ' True so scroll bars can move (at least

manually)
With FrameWeb
.ScrollBars = fmScrollBarsBoth
.ScrollTop = Horiz
.ScrollWidth = FVert
End With

Gary

"NickHK" wrote:

Gary,
Looks like it's the same.

NickHk

"gary" wrote in message
...
Nick,

Yes yes !! The cross hairs now move on top of the browser !!

One
last
(I
hope) question. How do I control the scroll bar positions in

WebBrowseer1
from my vba program. I used to control the IE browser object with
ie.document.parentWindow.Scroll horiz, vert

Thanks for your help,

Gary






 
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
cross hair johnpotter94501 Excel Discussion (Misc queries) 7 November 24th 09 01:18 PM
Row Column Cross Hair h2fcell Excel Worksheet Functions 3 October 1st 08 04:32 PM
How do I change the cursor from cross to arrow Famil Club Excel Discussion (Misc queries) 1 August 31st 06 10:23 AM
HOW DO I CHANGE THE EXCEL CURSOR TO AN ARROW FROM A CROSS ? Accellerate Excel Worksheet Functions 1 May 28th 06 12:09 AM
Can I change the "white cross" cursor in Excel to another cursor? KFEagle Excel Discussion (Misc queries) 1 May 3rd 05 08:01 PM


All times are GMT +1. The time now is 02:35 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"