View Single Post
  #24   Report Post  
Posted to microsoft.public.excel.programming
NickHK[_2_] NickHK[_2_] is offline
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