View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Gary is offline
external usenet poster
 
Posts: 273
Default VBA - Click mouse to change cursor to cross hair that spans th

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

"NickHK" wrote:

gary,
Sorry, forgot I had changed the 2 x labels to 2 x frames.
Also, make sure the frame containing the browser is behind the 2 frames;
right-click on the frame's border and "Send Backward".


"gary" wrote in message
...
Nick,

Yes, I even added "Frame1.enabled = false" to no avail. The cross hairs
go behind the frame.

Any ideas ?

"NickHK" wrote:

Gary,
That works for me.
Sure you have Frame1.Enabled=False ?
You can have a button to toggle the .Enabled state of the frame.

NickHK

"gary" wrote in message
...
Nick,

I tried what you suggested (Browser inside Frame that is disabled) but

no
difference. The cross hairs do not cover the frame either. The user
might
want to get control of the browser which I could accomodate with a

button
I
could add on the UserForm.

Gary

"NickHK" wrote:

Gary,
I'm no expert in this (or Excel for that matter..), but this now

sounds
like
it has little to do Excel as such.
Whilst you can reparent IE to your userform, I see no way to respond

to
mouse movements (without sub-classing or something). Also, how do

you
intend
to draw your cross hairs ?
I'm not clear on why you need to do this. You say "so the user can

more
accurately get values that are displayed along the borders".
So what do "get values" mean ?

NickHK

"gary" wrote in message
...
Nick,

The IE browser is completely separate from the User Form. The

code to
control the browser resides on the user form which is kicked off

from
excel
after the user has set several parameters. So besides needing to

put
cross
hairs on the IE browser, the cross hairs need to be responsive to
mouse
movements on the browser.

Gay



"NickHK" wrote:

Gary,
But you are attempting to draw cross hairs on IE that is

completely
separated from your userform and Excel ?
Or you do have a web browser control on your userform ?

NickHK