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
|