View Single Post
  #24   Report Post  
Posted to microsoft.public.excel.programming
Gary Gary is offline
external usenet poster
 
Posts: 273
Default VBA - Controlling browser scrollbars from vba

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